insert current date in header record & trailer count

Bhuvaneswari K · New User Joined: 15 Sep 2008 Posts: 17 Location: Chennai

Hi,

I'm writing a sort job to merge the data records of 4 different files. The 4 files will not have header and trailer record.

But the merged output file should have a header record with current date in it and a trailer record with the count of records.

Please advise on how this can achieved .

thanks,
bhuvana

Arun Raj · Posted: Thu Jul 22, 2010 6:02 pm

Are you MERGEing the files based on any key? If yes, what about the starting position,length and format of the key field in the input files? And remember in order to do a 'MERGE' the files must be presorted on the key field.
Or you just want to concatenate all the input files?

What about the LRECL/RECFM of input files?

And the format of Date that you want in the header-ddmmyy? mmddyy or mmddyyyy or what?

Bhuvaneswari K · New User Joined: 15 Sep 2008 Posts: 17 Location: Chennai

The date format is yyyymmdd. the files are of lenght 80, q-sam files.

thanks,
bhuvana

Arun Raj · Posted: Thu Jul 22, 2010 6:11 pm

Frank Yaeger · Posted: Thu Jul 22, 2010 10:42 pm

bhuvana,

Please show an example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files. If a file can have duplicates within it, show that in your example.