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

gabriel.ryoga · New User Joined: 07 Jun 2007 Posts: 27 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:

arcvns · Posted: Wed Aug 20, 2008 3:02 pm Post subject:

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: 27 Location: Spain

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

gcicchet · Senior Member Joined: 28 Jul 2006 Posts: 648

Hi,

try this

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

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 · Senior Member Joined: 28 Jul 2006 Posts: 648

Hi Frank,

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

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

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.