How to outrec fields from duplicate records?

niks_jude · Posted: Mon Jul 09, 2007 1:52 pm

I have two files ----

File 1:
sortkey1 F1 F2

File 2:
sortkey2 F3 F4

The sortkey1 and sortkey2 are at same position and of same length in both the files. The fields F1 and F2 are different and at different locations from F3 and F4.

I need a sorted output such that if sortkey in File1 of any record matches that of any record in File2 then output should be the following ---

Sortkey F1 F2 F3 F4.

Also would sort be the best option?

murmohk1 · Posted: Mon Jul 09, 2007 1:57 pm

niks_jude,

Use the Join fields from two files on a key Smart DFSORT Trick from the sorttrck.pdf available in the link below -

www.ibm.com/servers/storage/support/software/sort/mvs/tricks/

niks_jude · Posted: Mon Jul 09, 2007 3:13 pm

Thanks.It solved my problem.