Joined: 16 Mar 2009
I have two file file1 and file2. I am matching two files with three keys,
File 1 key 1 = File 2 key 1
File 1 key 2 = File 2 key 2
File 1 key 3 = File 2 key 3
Using the below sort, i joined the three keys. But After a match happens I need to overlay a record from file 2 position (25,3) to file 1 (205,3) in the include section. When there is no match I need to write it to mot condition. Finally I will merge this two files.
Apart from how to write a separate file which will have changed record details. I can write a separate for the matched records to extract the keys and other fileds with inlcuding some conditions. But is it possible to do that in this step itself.
OMIT COND=(1,10,CH,EQ,C' ')
After a match happens I need to overlay a record from file 2 position (25,3) to file 1 (205,3) in the include section