Splice two files to a single file using SORT

guruji · New User Joined: 13 Apr 2007 Posts: 59 Location: Chennai

I have two files 1 with student name in the first field, having 10 records and blank in the rest of the fields & the second file, also having 10 records having blank in the first field and student details in the second field. I want to splice these files to a single file so that i get the student name in the first field &student detail in the second field.

expat · Posted: Fri Apr 20, 2007 5:14 pm

Is there a common key ?

guruji · New User Joined: 13 Apr 2007 Posts: 59 Location: Chennai

There is no common key as of now.But it assumed that both the files are in sorted order.and the first record in the file 1 corresponds to the first record in file 2 and so on.

Frank Yaeger · Posted: Fri Apr 20, 2007 8:13 pm

You can use the method discussed in the "Join fields from two files record-by-record" Smart DFSORT Trick at:

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