split a file in 2 files and count the total of the records

gabriel.ryoga · New User Joined: 07 Jun 2007 Posts: 31 Location: Spain

I need to split a file in two files and put the total count of the records in file1 and file2 in a third file:

INPUT:

Arun Raj · Posted: Wed Aug 20, 2008 3:02 pm

gabriel.ryoga,

What are the LRECL/RECFM of the files? What are the key positions?

Thanks,
Arun

gabriel.ryoga · New User Joined: 07 Jun 2007 Posts: 31 Location: Spain

Record length = 3, and de key is in position 1,3

gcicchet · Posted: Wed Aug 20, 2008 3:57 pm

Hi,

try this

Frank Yaeger · Posted: Wed Aug 20, 2008 9:16 pm

Gerry,

Why would you use SECTIONS and TRAILER3 for the total count instead of just using TRAILER1? Note also, that your job sets the LRECL of OUTPUT3 to 80 (since your input file has LRECL=80) instead of 3. Actually, with an input file with LRECL=3, your job would terminate.

The correct last OUTFIL statement would be:

gcicchet · Posted: Thu Aug 21, 2008 3:34 am

Hi Frank,

my code missed the INREC statement when I cut and pasted it

Frank Yaeger · Posted: Thu Aug 21, 2008 4:21 am

I still don't understand why you think you need to set up a value in position 4 with INREC and use SECTIONS and TRAILER3 when you can just use TRAILER1 without INREC to get the total count more easily as I showed.