I have two input files, File1 & File2.I want to join the matcing records to the Output file.(Input files with RECL=50 and Output file with RECL=80)
I want to compare File1 {Key1(11,6) + Key(1,7)}
with File2 {Key(1,13)} .If this matches i will join File1 and File2
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
Vinod,
Quote:
I want to compare File1 {Key1(11,6) + Key(1,7)}
with File2 {Key(1,13)} .If this matches i will join File1 and File2
The key positions you mentioned above and that given in the "Code" does n't seem to match. Also you dont need a JOIN UNPAIRED,F1 unless you want to write unmatched records also from file1
If you need only the matching records in your output you can use a Syncsort job like this.
