Editing trailer record in my input file

prav_06

Hi All,

I have a requirement to eliminate duplicate records from a flat file, I know it can be done by giving SUM FIELDS = NONE in a sort job, but in my case I have a header record and a trailer record in my input file, and the trailer record consists of the number of records present in the file , pls find the sample file below

004102007 PGM1
1record1
1record2
1record3
904102007 03

The above would be my data inside my file and the trailer record as specified contains the number of records in the file, I have to remove the duplicate in my file but also modify the number of records in my trailer record accordingly, I don;t want to use a COBOL pgm for the sam e , can it be done by SORT, If so please share the sort card. Thanks in advance

Thamilzan.

murmohk1 · Posted: Thu Oct 04, 2007 11:41 am Post subject: Reply to: Editing trailer record

Thamilzan,

How do you recognize Header & Trailer records? Are they going to be constant across runs (leaving record count).

murmohk1 · Posted: Thu Oct 04, 2007 11:42 am Post subject:

Also, post your file attribs along with sort key details.

prav_06 · Posted: Thu Oct 04, 2007 3:22 pm Post subject:

Hi Murali,

The header record would be identified by '0' in the first byte and the data record would be havin '1' in the 1st byte and the trailer record would be havin '9' in the 1 st byte, the DCB parameters are 80 lrecl and 800 blk and FB format, the header record and trailer record remains constant

Thamilzan.

murmohk1 · Posted: Thu Oct 04, 2007 4:17 pm Post subject:

Prav,

krisprems · Posted: Thu Oct 04, 2007 4:19 pm Post subject:

prav_06

murmohk1 · Posted: Thu Oct 04, 2007 4:26 pm Post subject:

KirsPrems,

prav_06 · Posted: Thu Oct 04, 2007 4:43 pm Post subject:

Hi Murali,

Thanks a lot for the solution.

Thamilzan.

prav_06 · Posted: Fri Oct 05, 2007 7:20 pm Post subject:

Hi,
Say if the header record is not constand and would vary for each run how the above JCL can be modified. Thanks in Advance.

Thamilzan.

Frank Yaeger · Posted: Fri Oct 05, 2007 9:30 pm Post subject:

Thamilzan,

Here's a DFSORT job that will handle varying header and trailer records. It creates DFSORT Symbols for the header and trailer information and then uses those Symbols in HEADER1 and TRAILER1.

prav_06 · Posted: Tue Oct 09, 2007 6:56 pm Post subject:

Hi Frank,

I got the JCL but as per my requirements (Which changes Often!!!!!), I need to add 2 to my record count at my trailer record, say if there are 5 data records , the downstream PGM expects the record count as 7 (5 data recs and 1 header and 1 trailer record), could you please suggest how this can be done. Thanks in advance.

Thamilzan.

Frank Yaeger · Posted: Tue Oct 09, 2007 8:44 pm Post subject:

Just change the last line to:

ajay_diaz · New User Joined: 12 Sep 2005 Posts: 22

I am able to calculate the record count and sum of the input fields.
But is it possible to place the record count and sum total in a particular place in the trailer record?
e.g.
I need to add the trailer record at the end of the file. My input file is 751 byte file but i am dealing with only following few fields for the trailer record creation:
2nd byte in input contains S9(9) COMP-3
7th byte in input contains S9(3) COMP-3

I want to create a trailer record in output file such that
2nd byte contains 999999999
7th byte contains 999
10th byte contains record count in the file
14th byte contains sum of values in 2nd byte in input file
22nd byte contains sum of values in 7th byte in input.

all the above fields are packed decimal fields.

Thanks!

Frank Yaeger · Posted: Wed Mar 26, 2008 9:03 pm Post subject:

You can use c: in TRAILER1 to indicate the column in which an item should start, e.g.