Count the number of records in a file using SORT

[RajendraPrabhuS]

Hi, I just want to count the number of records in a file using JCL. Is there any utility to count the number of records? Can anyone help me on this please..

[expat]

Let us clarify exactly what JCL is.

it is Job Control Language.

By itself it does nothing. It is used to invoke the chosen program and to define which datasets are to be used by the DD names associated with the chosen program.

JCL does not have magical powers that solve all problems, JCL is merely the vehicule for telling the processor which program you want it to execute.

So which program do you wish to execute to count the records ?

[RajendraPrabhuS]

Thanks Swd....

[Alissa Margulies]

If you have SyncSort for z/OS, here is a sample job that will produce the record count:

Code: Select all

//SORT1 EXEC PGM=SORT 
//SYSOUT  DD SYSOUT=*               
//SORTIN  DD DSN=Input.File,DISP=SHR 
//SORTOUT DD DSN=Output.File,...
//SYSIN   DD *                       
   SORT FIELDS=COPY                   
   OUTFIL FILES=OUT,TRAILER1=(1:COUNT),REMOVECC,NODETAIL           
/*                                   

[RajendraPrabhuS]

Hi Alissa Margulies, Thank for this... Can you please explain the following line.. I don't understand..

SORT FIELDS=COPY
OUTFIL FILES=OUT,TRAILER1=(1:COUNT),REMOVECC,NODETAIL

[Alissa Margulies]

RajendraPrabhuS,

This job creates a report with a single trailer record containing the record count.

The COUNT subparameter of TRAILER1 provides the number of records for the entire report (all the records) starting at position 1.

REMOVECC omits the ANSI carriage control character from all of the report records.

NODETAIL generates a report with no data records, only header and trailer records, as specified.

Hope this helps. Let me know if you have any further questions.

P.S. All of this is fully documented in the SyncSort for z/OS Programmer's Guide. If you are a licensed customer but do not have access to the documentation, please contact SyncSort Mainframe Product Services and we would be happy to provide them to you.

[RajendraPrabhuS]

Thanks you soo much Alissa

[sricsc]

I have a question, can I count the total records in more than one PS file in the same SYNCSORT step ?

[ranga_subham]

Yes. In that case you would be using PGM=SYNCTOOL instead of PGM=SYNCSORT.

Thanks.

[sricsc]

Hi Ranga,

Thanks for your response.
But I dont know the how to use the SYNCTOOL. Can you pls tell me the SYNCTOOL syntax & how to use in my job ?
And also how to check the SYNCTOOL is installed in my system ?