format the input file if values are not given properly?

Other Mainframe related questions which attracts you and there is no suitable Forum you find for it and related FAQs.
Post Reply
Kapil Sharma
Registered Member
Posts: 52
Joined: Sun Sep 29, 2013 1:46 am
Location: India

format the input file if values are not given properly?

Post by Kapil Sharma »

Guys - how to format the input file if values are not given properly??
Thanks,
Kapil
User avatar
Anuj Dhawan
Founder
Posts: 2802
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Contact:
India

Re: format the input file if values are not given properly?

Post by Anuj Dhawan »

You might want to elaborate your question, I believe.
Thanks,
Anuj

Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
nicc
Global Moderator
Global Moderator
Posts: 691
Joined: Wed Apr 23, 2014 8:45 pm

Re: format the input file if values are not given properly?

Post by nicc »

What do you mean by 'format'? What do you mean by 'file' (mainframes generally store data in data sets)? What values?
Regards
Nic
User avatar
Robert Sample
Global Moderator
Global Moderator
Posts: 1896
Joined: Fri Jun 28, 2013 1:22 am
Location: Dubuque Iowa
United States of America

Re: format the input file if values are not given properly?

Post by Robert Sample »

You need to be aware that formatting is external to the data set -- the same characters may mean different things if formatted differently. For example, X'97994D' can be interpreted as 'pr(' if formatted as characters, or -97994 if formatted as packed decimal (COMP-3 in COBOL) or 9935181 if formatted as binary (COMP in COBOL). Which format is correct? There is no way to tell from the data set -- you must have an external indicator as to which one to use.
Kapil Sharma
Registered Member
Posts: 52
Joined: Sun Sep 29, 2013 1:46 am
Location: India

Re: format the input file if values are not given properly?

Post by Kapil Sharma »

I wanted to make them sorted. As the files were getting data in no order. I could use SORT job to do that.
Thanks,
Kapil
nicc
Global Moderator
Global Moderator
Posts: 691
Joined: Wed Apr 23, 2014 8:45 pm

Re: format the input file if values are not given properly?

Post by nicc »

Why so long to respond?

If you mean that you simply need to sort the data then sort it using the sort product installed at your site. Syncsort and DFsort have similar, but not always identical, control statements. For a simple sort such as you are suggesting then the control statements will be identical.

The Dfsort manuals can be found here https://www-01.ibm.com/support/docview. ... g3T7000080
Regards
Nic
Kapil Sharma
Registered Member
Posts: 52
Joined: Sun Sep 29, 2013 1:46 am
Location: India

Re: format the input file if values are not given properly?

Post by Kapil Sharma »

I don't have access to this site from work and needs to go to library most of the times or access it from phone. I'll look for SORT.
Thanks,
Kapil
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Return to “Other Mainframe Topics, Off-Topics, FAQs.”