mfsrini Beginner
Joined: 10 Aug 2006 Posts: 11 Topics: 6
|
Posted: Fri Oct 07, 2011 9:13 am Post subject: comparing two files and writing the 2nd file records to outp |
|
|
Hi,
My requirement is as follows:
I need to compare 2 files (eg: yesterday file, today file) and I need to write the differences to 3rd file
constraints:
1) If there is difference b/w first file record fields with second file record fields, then write second file record to output file.
2) first file has record but second file doesn't, then we need to ignore that record.
3) second file has record but first file doesn't, then we need to write that record from second file.
4) One of the field is timestamp in both files (position 10). While comparing, we should ignore this field.
Please let me know Is it possible to execute through JCL sort utilities.
Regards,
Srini |
|