Page 1 of 1

two reports to compare , both different format - URGENT

Posted: Wed Jul 15, 2009 10:53 am
by ar3
Hi All/Frank,

I have two reports which are of different format. each field's values are to be compared and match and mismatch records are to be pulled out of it.. im think of seperating all the account numbers by the first two numbers in a separate file and the sorting them into one file and then comparing them .. is it a good way.. or u have another idea.. if its ok can u give me some similiar code ...

thanks,
Arthi

Posted: Wed Jul 15, 2009 7:57 pm
by Frank Yaeger
Since it's "URGENT", you should have given more details so somebody could help you. You haven't given enough information for me to guess what you're trying to do.

Perhaps the technique shown in the "Create files with matching and non-matching records" Smart DFSORT Trick will help. It's at:

http://www.ibm.com/support/docview.wss? ... g3T7000094

If you need more specific help, show an example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files. If file1 can have duplicates within it, show that in your example. If file2 can have duplicates within it, show that in your example.