SYNCSORT Compare date in 2 files

sivatechdrive · Posted: Sat Jan 10, 2009 4:23 pm

HI All,

I have a reqirement and the details are given below.plz help me on how to proceed

FILEA will have header and detail records (header also has date)
FileB also has header and detail records (header also has date)

Need to compare the dates in both the files (header record) and write the maximum to the OUtput File.

Thanks
Prasad

Arun Raj · Posted: Sat Jan 10, 2009 8:58 pm

Prasad,

Post a few sample records from both the files. What about the input/output file attributes-RECFM/LRECL?

Anuj Dhawan · Posted: Sat Jan 10, 2009 9:25 pm

sivatechdrive · Posted: Mon Jan 12, 2009 8:09 am

HI.,

The input files are of Fixed format and LRECL = 110.

The Header and data records in file1
00000020081031
001 ABC
003 DEF
007 IJK
The Header record in file2
00000020081231
002 LMN
005 OPQ
008 RST

The Expected Output file
(the date in the header should be maximum among the 2 input files
i.e 20081231 (input file2) is > 20081031 (input file1) hence file2 header is choosen )

00000020081231
001 ABC
002 LMN
003 DEF
005 OPQ
007 IJK
008 RST

Thanks
Prasad

Arun Raj · Posted: Mon Jan 12, 2009 10:35 am

Prasad,

Can the header be identified by the one starting with 5 '0's?
Do you have unique keys ( position 1,3 ? ) in both the files?