Merge Header and trailer Records

vsrao_2k · New User Joined: 12 Dec 2005 Posts: 13

Hi Frank,

I am having a flat file of length 80(LRECL). I am having Header,Trailer and detailed records in the file of same length. I want the date from header record + No.of records from the trailer record. How to do this using ICETOOL?

I have included INCLUDE COND(1,3,CH,EQ,C'PID',OR,
1,3,CH,EQ,C'TRL') which will filter Header and trailer records.

But I want header record date which is at 10,6 + Total no.of records from trailer record 10,6 in the same record in the output file.

Please suggest me.

Thanks
Sreenivas.

CICS Guy · Posted: Tue Jan 26, 2010 12:39 am

Please post a sample of your input and what you want the output to look like.
Please post lrecl and recfm of the input and output.

vsrao_2k · New User Joined: 12 Dec 2005 Posts: 13

Input file: LRECL=80 and RECFM=FB

CICS Guy · Posted: Tue Jan 26, 2010 1:40 am

Will there be multiple sets of HDR/DETAIL/TRL groups in a single input?

vsrao_2k · New User Joined: 12 Dec 2005 Posts: 13

No. There is be always only header and one trailer record will be available in the file. But Detailed records will be N.

Frank Yaeger · Posted: Tue Jan 26, 2010 2:45 am

Here's a DFSORT job that will do what you asked for:

Escapa · Posted: Tue Jan 26, 2010 3:24 am

Even this sort card will do too

vsrao_2k · New User Joined: 12 Dec 2005 Posts: 13

Thank you. Both solutions are working good. Thanks once again.