Join Files on a key

shanudarling · New User Joined: 20 Dec 2006 Posts: 55 Location: noida

My requirement is as follows -
There are 2 files A & B.

File A contains a unique list of customer numbers.

File B contains customer numbers & some data. There can be multiple records for the same customer number in this file.

Now I have to create an output file containing the data from file B for all those customer numbers which are present in file A.

File A

Garry Carroll · Posted: Tue Oct 04, 2011 6:03 pm

Please use code tags and not attachments or .jpg files. for your sample data. Your sample File A seems to include line numbers which are not seen in Sample File B or Sample output C. Presumably the 5-digit number is the key for joining? What is your RECFM LRECL (and all the usual information that you should have supplied)?

Given the correct information, the solution can easily be found in Smart DFSORT Tricks @

www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000094

Garry.

enrico-sorichetti · Posted: Tue Oct 04, 2011 7:01 pm

after five years You should have learned not to post screenshots
nothing that a plain text cut and paste could not have done
the topic has been editet to delete the images and use plain text

Frank Yaeger · Posted: Tue Oct 04, 2011 10:15 pm

sd,

You can use a DFSORT job like the following to do what you asked for. I assumed your input files have RECFM=FB and LRECL=80, but the job can be changed appropriately for other attributes.