Hi,
I have two files with 1 record in each file. The file is in the format CCYYMMDDHHMMSS. Starting position 1 and End position 14 in both files.
Ex: File1 contains 20090621152250 and file 2 contains 20090621112143
my requirement is to see if the time difference (time part in File1 - time part File2)is GE to 4 hours. ( i.e 152250 - 112143 should be >= 4 hours).
I would like to get a RC16 if the condition fails else RC0.
My shop will support only SYNCSORT. Please help me in acheiving this requirement.