Pass the count of records to the next step of Jcl

gekalpana · New User Joined: 11 Apr 2007 Posts: 12 Location: Chennai

Hi
I want to get the count of records present in a sequential file and pass it to the next step in the jcl .. is that possible ..?? If yes , please let me know how to achieve that ??

Thanks !!

expat · Posted: Thu Apr 26, 2007 12:32 pm

You can use SORT, ICETOOL, IEBGENER to get a count of records, then you need to read the output to get the record count, and write it out.

gekalpana · New User Joined: 11 Apr 2007 Posts: 12 Location: Chennai

Without reading the output file is there any other way ??

murmohk1 · Posted: Thu Apr 26, 2007 12:58 pm

kalpana,

gekalpana · New User Joined: 11 Apr 2007 Posts: 12 Location: Chennai

Ok .. Thanks !!

expat · Posted: Thu Apr 26, 2007 1:11 pm

By output I meant the SYSOUT DD statement from DFSORT, or SYSPRINT from IEBGENER.

There is no need to actually copy the data with SORT / IEBGENER, you can use DD DUMMY for the SORTOUT / SYSUT2 statement.

murmohk1 · Posted: Thu Apr 26, 2007 1:31 pm

Expat,

Actually you can get the record count only (not the data) into a file flat (not sysout) using DFSORT Trailer option. As Kalpana wanted to pass the record count to next step I guess this option is best (as sysout contains other data also and needs to be filtered for the count).

expat · Posted: Thu Apr 26, 2007 1:39 pm

Yes, good point.
Will the count be in PD or character format ?

murmohk1 · Posted: Thu Apr 26, 2007 2:11 pm

Frank Yaeger · Posted: Thu Apr 26, 2007 9:26 pm

The "Display the number of input or output records" Smart DFSORT Trick at:

www.ibm.com/servers/storage/support/software/sort/mvs/tricks/

shows how to use TRAILER1 to get one record with the count. The example gets the count as a ZD/CH value, but it can easily be changed to get the count as a PD value by using: