File matching (1:1) using Joinkeys

neopandya · New User Joined: 02 Mar 2010 Posts: 8 Location: Bangalore

Hi,

I have a requirement wherein I am trying to do a 1:1 file match using JOINKEYS.

File1 - lrecl (8)

neopandya · New User Joined: 02 Mar 2010 Posts: 8 Location: Bangalore

Made a mistake in my expected output

nelson.pandian · Posted: Fri Nov 26, 2010 11:59 am

Hi Neo,

File1 does not contain the record 33333ggg. Then how can you expect to get that record in your output file?
The Below Control card will you the expected out put of your initial post.

neopandya · New User Joined: 02 Mar 2010 Posts: 8 Location: Bangalore

Hi Nelson,

Apologies for the confusion with my examples. Let me try to state my requirement again, with a different example.

Input1 (lrecl=10, Key=1,5)

Frank Yaeger · Posted: Tue Dec 07, 2010 12:20 am

Here's a DFSORT JOINKEYS job that do what you asked for. From your examples, I'm assuming that input file1 does not have duplicates and input file2 does have duplicates, and you want the matching input file1 records as output.