Processing Mutiple Header and trailer records in a file

sasidarauthur · New User Joined: 13 Jul 2006 Posts: 5 Location: chennai

Hi,
I stucked up with processing mutiple header and trailer records
in a single file
here is the requirement

I/P:
HDR000325
abcd Y
CDEF N
sdfg N
adbf Y
TRL00032500004
HDR000326
1234 Y
asde Y
sdfgk N
adbfh Y
2345 N
TRL00032600005

I nee output as below

HDR000325
abcd Y
adbf Y
TRL00032500002
HDR000326
1234 Y
asde Y
adbfh Y
TRL00032600003

Any type of suggestions using Sync or DFsort helps. Icetool is not available for me to use

thanks a lot for help

Sasidar

Frank Yaeger · Posted: Thu Feb 03, 2011 12:10 am

What is the RECFM and LRECL of your input file?

What are the "rules" for getting from input to output?

What is the starting position, length and format of the relevant fields in your input records?

sasidarauthur · New User Joined: 13 Jul 2006 Posts: 5 Location: chennai

Hi Frank,

Recfm is FB and 80 LRECL
1. There will eiter Y or N in the 80th charater of the file for all detailed records
2. For Header and trailer 80th caracter is spaces
3. Header will start with 'HDR' followed by Seq number (in ex: 000325)
4. Trailer will start with 'TRL' followed by seq number followed by records count for respective sequence number

Output should have all the detailed records with a Y in 80th caracter under respective header Trailer sequence

Please let me know if you need any further info thanks

Skolusu · Posted: Thu Feb 03, 2011 1:50 am

sasidarauthur,

Use the following DFSORT JCL which will give you the desired results

sasidarauthur · New User Joined: 13 Jul 2006 Posts: 5 Location: chennai

Thanks Kolusu, it is working good for my requirement.