MVSFORUMS.com

deep81this · Beginner Joined: 26 Apr 2011 Posts: 4 Topics: 2

I have a requirement in which
File-1
pos 1-13 is the sort key for all records other than starting with '8 44' or '8 40' ;
col 14 can have 2,3,4 etc which denotes transaction type. If there is a 4 type, it shud come only after 3 type and always comes as a pair.
Records of '8 44' starting at pos 2 can come as a byproduct of record type 3, as a different record.
Records of '8 40' starting at pos 2 comes as a trailer for every break in pos 1-7(key within main sort key).

deep81this · Beginner Joined: 26 Apr 2011 Posts: 4 Topics: 2

output file shud be like:

Result file:

kolusu · Posted: Wed Mar 30, 2016 11:37 am Post subject:

deep81this,

I am not sure as to why you posted this question in Application programming forum where this type of questions belong to Utilities forum.

Please answer the following questions

1. What is the LRECL and RECFM of file1
2. What is the LRECL and RECFM of file2
3. What is the LRECL and RECFM of the Output file?

Did you try using DFSORT Joinkeys and see if you can get the desired results?
_________________
Kolusu
www.linkedin.com/in/kolusu