Joined: 03 Nov 2006 Posts: 87 Location: Plymouth, MN USA
There are 2 files, FILE1 & FILE2, I want to retrieve records from both the files on matching key and only desired columns to be written to output file. Following is an example to decipate the same viz.
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
Quote:
Following is an example to decipate the same viz
Please clarify what this means in English.
Quote:
Hope I am clear with the requirement.
No. Your request is not clear. Please post some sample data from the 2 nput files and the desired output from processing that input. Also include the recfm, lrecl, and the positions of the relevant fields for your requirement.
Joined: 03 Nov 2006 Posts: 87 Location: Plymouth, MN USA
Thank you for your interest. I have somehow created a JCL to do this but still struck with somethings. Hope following example will clear my requirement:
As discussed in example above, File1 contains ID + file1 Info and File2 contains ID + Designation + File2 info. Now my requirement is to match ID in both files and write output with their
ID+ FIle1 Info + Designation+File2 Info.
Note: If File2 has duplicate ID then multiple records to be written, as in 1234567