Skip Header and Trailer and then merge all records again

Bharti P Manglani · New User Joined: 13 Mar 2007 Posts: 16 Location: Pune

Hi All,

I have a file with header, trailer and remaining records. I need to omit my header and trailer and sort remaing records.

Then again I need to merge my sorted records along with my Header and Trailer records.

I can use OMIT COND to omit my header and trailer records. But then once I have temporary file with my sorted records; how do I merge all records (header,trailer and sorted ones) again?

Can header and trailer records be stored in Temporary files also after omitting them?

Arun Raj · Posted: Fri Nov 13, 2009 12:33 pm

Bharti P Manglani,

If you provide some more details, somebody will be able to help.

1. How does your header/trailer records look like?- Are they fixed or can vary based on the input?
2. Is there something in your header/trailer records which can be used to dstinguish them from the data records. for e.g. 'HEADER' at pos 1-6 for header record.
3. Input and output RECFM/LRECL
4. position,length and format of the key field.

Frank Yaeger · Posted: Fri Nov 13, 2009 10:43 pm

BM,

You can use the DATASORT operator of DFSORT's ICETOOL to do this kind of thing. For more information, see the "Sort detail records between headers and trailers" Smart DFSORT Trick at:

www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000094