Posted: Tue Dec 18, 2012 3:19 pm Post subject: Compare Current day file with previous day file using JCL
I want to achieve the below scenario by using JCL because my files are having millions of records.
I need to compare current days file with the previous days file and create one output file with the following details:
1) Records present in file1 and not in file2--Records are added.Write File1 records in output file with indicator A at the end.
2) Records present in file2 and not in file1--Records are deleted.Write File2 records in output file with indicator D at the end.
3) Key is same in File1 & File2 but other value changed--Records are modified.Write File1 records in output file with indicator C at the end.
FFFFFF HHHH C
GGGGGG RRRR A
LLLLLL UUUU A
VVVVVV LLLL D
Hope the requirement is clear, appreciate your help!!.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum