Help to perform delete for COMP-3
Posted: Tue Oct 21, 2014 6:27 pm
Hi Team,
I have a situation where need to perform deletion of COMP-3 field data from FILE#1 that are present in File#2 but in Numeric value.
Please suggest a logic to perform the same, this has to be done in a faster way to avoid any delay.. as the FILE#1 is allocated to Online.
Any help will be appreciated.
Thanks,
Jaya
Background of the issue :
We have two files to be compared and found unmatched records. File-A and File-B. Both the files were SORTED to convert COMP-3 to Numeric and then performed compare. Now I have File-C with Unmatched records from File-B (This is in Numeric Format) Now I delete File-C records from File-B. But how do I do?
File-B has the field in COMP-3
File-C has the field in Numeric format.
I have a situation where need to perform deletion of COMP-3 field data from FILE#1 that are present in File#2 but in Numeric value.
Please suggest a logic to perform the same, this has to be done in a faster way to avoid any delay.. as the FILE#1 is allocated to Online.
Any help will be appreciated.
Thanks,
Jaya
Background of the issue :
We have two files to be compared and found unmatched records. File-A and File-B. Both the files were SORTED to convert COMP-3 to Numeric and then performed compare. Now I have File-C with Unmatched records from File-B (This is in Numeric Format) Now I delete File-C records from File-B. But how do I do?
File-B has the field in COMP-3
File-C has the field in Numeric format.