two file match the records and writ out file

pnsnaresh · New User Joined: 16 May 2006 Posts: 7 Location: pune

Hi,
I have 2 sorted files A and B(empid empname). now match record of A with B if matched write AB in C, unmatched write A in to D, Brecords not in A write in E.

input files : A,B
output files: C,D,E

Thanks in advance
Naresh

William Thompson · Posted: Tue Jan 23, 2007 10:18 pm

Go look here, it was all discussed a couple weeks ago http://www.ibmmainframes.com/viewtopic.php?t=16806
Also, it is further explained in the great PDF Create files with matching and non-matching records