Count the number of records in a file using SYNCSORT

nitinkhobragade1 · New User Joined: 07 Mar 2006 Posts: 16

Hi,

I want to count the number of records in a file and put that count in an output file.The output file should have only one record mentioning the record count.

The records format should be:

'The total number of records in the input file is:' count.

How can i do this using Syncsort?

William Thompson · Posted: Mon Mar 19, 2007 5:31 am

I think yes.
Infil a constant of one.
Sum on that constant.
Outfil reformatting the summed total into your phrase.
Have you checked your manual for the specifics?

guptae · Posted: Mon Mar 19, 2007 10:10 am

Hi there,

You can use following sort card to find number of records

nitinkhobragade1 · New User Joined: 07 Mar 2006 Posts: 16

Hi Ekta,

I have used your control card in the below jcl but the job is abending with maxcc=16

dick scherrer · Posted: Wed Mar 21, 2007 2:44 am

Hello,

This