Match input file using key and write to output file

raviprabhu · New User Joined: 20 Oct 2006 Posts: 29

Hi,

I have 2 input files with same record length (480)
I want to match the key (starting from 7 to length 17) if there is a match found in both input files then write to output file.

raviprabhu · New User Joined: 20 Oct 2006 Posts: 29

The input file contains duplicate records

dick scherrer · Posted: Sat Jan 25, 2014 12:27 am

Hello,

Suggest you read about JOINKEYS.

In addition to the sort documentation, there are many examples here in the forum. Use the SEARCH to find them.

Skolusu · Posted: Sat Jan 25, 2014 1:57 am

You can use DFSORT's JOINKEYS function for that. For some examples, see the "Create files with matching and non-matching records" Smart DFSORT Trick at:

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