compare two files on fields with different declarations

madishpa · New User Joined: 18 May 2007 Posts: 28 Location: Hyderabad

I need to compare two files on field with different declarations.

field on which files is to be compared is amount.

Input file1:

lrecl - 80, recfm - fb

Amount is first 8 bytes in first file . declaration is 9(5).9(2)

Inut file2 :

lrecl - 80, recfm - fb

Amount is first 5bytes in second file , declaration is s9(5)v9(2) comp-3.

If the amount in file1 matches with file2 , then record should be written to output file from first file

Output file :

Lrecl - 80 , recfm - fb

Could you please provide dfsort job for the above requirement.

Thanks
Madishpa

vasanthz · Posted: Fri Aug 12, 2011 1:22 pm

gylbharat · Posted: Fri Aug 12, 2011 3:53 pm

Please post some sample input data and sample output data....

sqlcode1 · Active Member Joined: 08 Apr 2010 Posts: 577 Location: USA

madishpa,
Do you have any other key fields that you can use (along with amount field) to match records from both the files? Using amount as a key field to match 2 files, makes your job more vulnerable to have many to many match, in which case you would end up with more number of matched record than present in your File1.

However, see if below works...

Craq Giegerich · Posted: Fri Aug 12, 2011 5:31 pm