COUNT operator of ICETOOL

Daphne · New User Joined: 28 Aug 2006 Posts: 27 Location: NY, US

Hi,

I have a sequential file with header and trailer records. I have to put the header and trailer records in a different file for processing.

I was thinking of using COUNT operator to do it (getting the count and pulling record1 and record(count-1) ). But I do not know how exactly to do this.

Appreciate if someone could provide some information on this or anyother better way to do this.

Thanks in advance,
Daphne

Frank Yaeger · Posted: Wed Oct 18, 2006 12:53 am

Daphne,

I need some more information before I can show you how to do what you want to do.

Is there anything that identifies the header (e.g. 'HDR' in positions 1-3) or trailer (e.g. 'TRL' in positions 1-3) or are they just identified by being the first and last record in the file, respectively?

What is the RECFM and LRECL of the input file?

Please show an example of your input records and what exactly you want for output (one output file with just the header and trailer? another output file without the header and trailer? or what?).

Daphne · New User Joined: 28 Aug 2006 Posts: 27 Location: NY, US

Hi Frank,

Thanks for the reply. Kindly find below the details.

1) Yes. The header and trailer will be identified only by them being the first and last record in the file respectively.

2) RECFM = FB , LRECL = 150

3) I need one file with just the header and trailer records and another file with the detail records alone.

4) Kindly find below the file layout(only header and trailer records).

File Header Record

Service Code 001 ? 003
Type of File 004 ? 004
Filler 005 ? 016
Year 017 ? 020
Pay Type 021 ? 022
Date File Created 023 ? 030
Time File Created 031 ? 036
Filler 037 ? 147
File Source Code 148 ? 150

File Trailer Record

Service Code 001 ? 003
Type of File 004 ? 004
Filler 005 ? 016
Year 017 ? 020
Pay Type 021 ? 022
Number of
Detail records 023 ? 033
Filler 034 ? 150

Thank you,
Daphne

Frank Yaeger · Posted: Wed Oct 18, 2006 3:15 am

Daphne,

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

Daphne · New User Joined: 28 Aug 2006 Posts: 27 Location: NY, US

Hi Frank,

Thanks a lot. I executed the JCL and then found out our shop is using SYNCSORT.

Anyway I have learned a lot. In the course of doing this I read your publications on DFSORT, ICETOOL and SYMBOLS. They are wonderful documents.

Thanks,
Daphne

Frank Yaeger · Posted: Fri Oct 20, 2006 1:17 am

Daphne,

If you or anyone else on this board would like some documents prepared by the DFSORT Team that describe what we see as the advantages of DFSORT over Syncsort, as well as considersations for migrating from Syncsort to DFSORT, send me an e-mail offline (yaeger@us.ibm.com). Please put "DFSORT" somewere in your Subject line to catch my attention.