MVSFORUMS.com

[koolspark]

hi,

I've a specific requirement to compare two files & write into two output files.

F1: (file1 can contain duplicates)
LRECL = 400
key = (110,06,CH)

F2:(file2 doesn't contain any duplicates)
LRECL= 2414
key = (01,6,CH)

I need to compare these two files on the keys & create two output files.
output file1 should contain all the records from F1 file(both matched and unmatched). if the key doesn't match, write the record as it is in the output file1 from F1 input file and if the key match then i should format the F1 file record as follows and write to output file1(overlaying few fields in file1 from file2) .
F1:1,144,F2:242,2,F2:351,2,F2:460,2,F2:569,2,F2:29,3,F2:82,3,F1:163,236

output file2 should only contain the unmatched records from F1 file.

Thanks,

[Sqlcode]

koolspark,
Try below untested...

In the overlay, you can actually overlay entire 14 bytes (from file 2) but i am showing them differenly for the ease of understanding...