merging two files without using splice

foliater · New User Joined: 06 Apr 2006 Posts: 31

Hi,
i have two files,
both with the same no. of records.
say
file1:
sara
sath
soor
sugu

file2:
1161
2345
2134
1221

output should be,
sara 1161
sath 2234
soor 2134
sugu 1221

LRECL no issue to be changed to whatever needed.

in splice it needs some keys to be there in both files. so i could not use that.

can anyone suggest some simple techniques to achieve this.

sril.krishy · Posted: Fri Aug 18, 2006 12:40 pm

Hi,
You can generate the sequence number for the file-1 and file-2 and then use the sequence number as the KEY to merge them horizontally.

Thank you
Krishy

Frank Yaeger · Posted: Fri Aug 18, 2006 8:09 pm

See the "Join fields from two files record-by-record" Smart DFSORT Trick at:

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

for an example of the technique you can use to do what you want with DFSORT/ICETOOL's SPLICE operator.