Compare 2 I/P files and write mismatch record in oneO/P file

[surindersingh]

I have a requirement where i have to compare 2 input files and incase of any mismatch record in any of the two input files i have to write records from both the files into one output file.

In other words, only one output file should contain two rows for each mismatched rows. Row from first file and then a row from second file in case on mismatch.

I know for comparison we can use JOINKEYS and JOIN UNPARED, but not able to achieve the above requirement.

If anyone did same thing before please share with me or provide any inputs which can help to achieve this requirement.

[William Collins]

This would give you two fixed-length (80) output records from the same input (your REFORMAT record).

Code: Select all

  OUTFIL BUILD=(1,80,/,81,80)

Have a look in the manual for the "/" (the slash operator) on OUTFIL BUILD.

[DikDude]

If the 2 files have a mis-match, how will there be 2 records to write into the output?

[Gurugars]

Please provide bit more clarity on your requirement.

Are the two files having same number of records? and each record from file1 should be compared with the same numbered/positioned record of other file. Say 10th record of file1 should be compared with 10th record of file 2? 11th to 11th and so on....?

[surindersingh]

Yes, the two files having same number of records and each record from file1 should be compared with the same numbered/positioned record of other file.

[William Collins]

In JNF1CNTL and JNF2CNTL generate a sequence number and append/preprend (depending on RECFM). Use the sequence number as the JOINKEYS key.

Pay attention to my previous post, which is accidently relevant.

[trushant]

try this for unmatch records

//SYSIN DD *
JOINKEYS FILES=F1,FIELDS=(139,18,A,
99,12,A,264,08,A)
JOINKEYS FILES=F2,FIELDS=(1,18,A,
23,12,A,40,08,A)
JOIN UNPAIRED,F2,ONLY
SORT FIELDS=COPY
END
/*