MVSFORUMS.com

[erasani]

Hi Team,

We have the below requirement. There are two input files. Please let me know if this can be achieved using DFSORT/ICETOOL.

- Input File1 has unique records in sorted order. First 20 bytes is the key. Next 5 bytes is the modified value i would like to overlay while writing into output file. Additionally, Records tagged as 'S' need to be skipped while writing into the output file.
- Input File2 can have multiple records per 1 key in Input File 1. These records are also in sorted order on First 20 bytes.
- Output File will have the records from Input file2. Based on the flag 'S' in Input File1, the corresponding records in Input File2 will be skipped. Input File2 has 9 records, where as Output File has only 8 records. For all the selected records, position 21-25 from Input File 1 need to be overlayed in Output file instead of the original values from Input File 2(Position 16-20).

Input File 1

[kolusu]

[erasani]

Thanks kolusu. Went thru DFSort tricks doc. Below code gave me the expected results.

[kolusu]

erasani,

By default JOINKEYS gives you only matched records. So you don't need to check the match indicator and rebuild the record once again as you can build the desired record using REFORMAT itself.