how to get the number for records for a list of datasets?

Bandita Bahubalendra · New User Joined: 08 May 2008 Posts: 15 Location: Bangalore

Hi All,

Can anyone tell me how to get the number of records for a list of datasets using REXX?

Thanks in advanvce!

Aaru · Posted: Wed Jul 15, 2009 12:42 pm

Using REXX might not be a good option as this can be easily done using SORT.

In REXX, you will have to read the files into a stem variable and the length of the stem variable will give the count of records.

expat · Posted: Wed Jul 15, 2009 1:46 pm

Why the need to know counts of records in a dataset.

Surely if this is a business requirement, the programs creating the datasets should give this information.

superk · Posted: Wed Jul 15, 2009 4:26 pm

I concur with all of the above responses.

Read the list, allocate each dataset one at a time, and run SORT to obtain the record count (see the product-specific SORT forums for details). Format the results as needed.