elsajthomas
New User
Joined: 30 Nov 2006 Posts: 6 Location: fort worth
|
|
|
|
Hi,
I have two FB files of the exact same length. Lets say for the sake of simplicity FB 100. The requirement is to
(a) Match the key (1,5,CH) for the first bytes and get all the records in File 1 which is not present on File 2 into file 3
(b) If key (1,5,ch) matches, then compare the date fields (6,18) (ccyy-mm-ddhh.mm.ss) and if the difference is either positive or negative 3 hours, then ignore that record, write remaining records into file 3
(a) is definitely possible in sort and i have done this. However can we do (b) as well either way directly or convert the date into hours/second and then do comparison and suggestions will definitely help.
Thanks
Elsa |
|