Record extraction using JCL Sort

Sumeendar · New User Joined: 31 Jan 2006 Posts: 39

Using JCL Sort i need to get values from same byte position from 2 different Input files and write to a single output file, for the comparing purpose

eg From input FILE 1 extract data from postion 118 to 130 and 186 to 232
From Input FILE 2 extract data from postion 118 to 130 and 186 to 232

Output FILE 3 will have extracted data from FILE 1 and FILE 3 like below

file 1 contents file 2 contents
File 3 -> 118 to 130 186 to 232 118 to 130 186 to 232

Any helps is appreciable

Thanks

Nic Clouston · Posted: Tue Apr 08, 2014 6:43 pm

Sample input and output plus RECFM and LRECL would be useful but you may be able to do this with JOINKEYS.

Sumeendar · New User Joined: 31 Jan 2006 Posts: 39

I used below Sort for the above objective, but Step S4 is failing with
AB = S013

Any help is appreciable

dick scherrer · Posted: Tue Apr 08, 2014 7:21 pm

Hello,

You have not posted the diagnosticds you were presented by the run . . .

Is the s013 an s013-20?

Why have you not posted the requested data?

Rohit Umarjikar · Posted: Wed Apr 09, 2014 3:30 am

Sumeendar,

As told, are the input files sorted? is/are there any common key(s) between two files? if answer to this is yes then the quickest way is to use JOINKEYS.

How is(&&S1)

Rohit Umarjikar · Posted: Wed Apr 09, 2014 3:43 am

However if there is no common key then you can use the trick "Join fields from two files record-by-record" from the below link (ofcource please do necessary modifications as per your offset instead of a whole record),

ftp.software.ibm.com/storage/dfsort/mvs/sorttrck.pdf

Bill Woodger · Posted: Wed Apr 09, 2014 4:13 am

You really have to clarify what it is you are trying to do.

Show a sample of data from both input files, and the expected output for that data, and a description of how that should happen.

Your S013 is probably because you haven't defined your SYMNAMES DSN as F/FB LRECL 80, which you could do by specifying an extra ..,80:X) where you are defining your record.

Please use BUILD instead of INREC/OUTREC FIELDS or OUTFIL OUTREC, which only exist for backwards-compatibility.

I don't think your generated symbol is doing what you want, even though I don't know what you want.

Sumeendar · New User Joined: 31 Jan 2006 Posts: 39

i have given SYMNAMES DSN as F/FB LRECL 80, by specifying an extra ..,80:X),

upon doing this my error as changs to ABENDU16 in Step S4 with below information

Bill Woodger · Posted: Wed Apr 09, 2014 11:39 am

Your have SyncSort (WER messages) not DFSORT, so your topic has been moved to the JCL forum where SyncSort questions live.

You have to take note of all that is said, and not just a bit which is superficially useful to you. I suggested your code would not work.

You are generating a symbol. Symbols have to be unique. Unless your file has only one record, this idea is not going to work.

If you describe, fully, answering anything remaining which was asked of you, there will probably be a reasonably short solution. But until we know what you want, including the compare part, there is not much point in suggesting anything.

Sumeendar · New User Joined: 31 Jan 2006 Posts: 39

okay i will be more precise on what i need

I have one file (namely FILE1) with multiple records having values 'VC111.242.1B' residing in position 118 to 130 and values 'C102C118' residing in position 192 to 200'

Similarly I have another file (namely FILE2) with multiple records having values 'VC111.242.1B' residing in position 118 to 130 and values 'C102C240' residing in position 192 to 200'

Using JCL SORT, i need to generate a 3rd file (FILE3), which contains above FILE1 and FILE2 values residing in below manner

VC111.242.1B C102C118 VC111.242.1B C102C240

I tried using SYSNAMES, but that do not support with multiple records. Is there a any better solution using SORT utility to attain the above objective

Thanks in advance

Rohit Umarjikar · Posted: Wed Apr 09, 2014 10:35 pm

Would you be kind enough to look at what I said and asked?

Sumeendar · New User Joined: 31 Jan 2006 Posts: 39

Thanks for providing the link -> ftp.software.ibm.com/storage/dfsort/mvs/sorttrck.pdf

This was really helpfull and indeed meet my requirements

Thanks again

Arun Raj · Posted: Fri Apr 11, 2014 3:20 pm

Sumeendar,

Please re-read all the posts and reply to the questions asked. Post some sample input records, some 4-5 records from both the files (showing relevant fields) and the expected output out of it and the rules by which you arrived at that output.