How to know the number of records within a dataset

madlui56 · Posted: Mon Jul 09, 2007 10:36 am

How to know the number of records within a dataset(flatfile) without going inside nor just typing max down(m f8) on the command line?

Thanks.

dick scherrer · Posted: Mon Jul 09, 2007 10:52 am

Hello,

To know the number of records "something" must "going inside"? The number of blocks might be found, but the number of records that would be read into a program, not. Space used is easily available externally, but number of records is not.

One easy way to find the number of records in a file is to use your sort product. If you search in the sort forum or even in this jcl section, you will find examples of getting a record count via sort.

I don't know a way to get a record count online without opening the file and "going inside".

Devzee · Posted: Mon Jul 09, 2007 10:55 am

Using FILEAID you can get the record count without opening the file.

madlui56 · Posted: Mon Jul 09, 2007 10:57 am

Where specifically on fileaid or on what command?
Thanks.

Devzee · Posted: Mon Jul 09, 2007 11:01 am

Option 3, and then 8

Aaru · Posted: Mon Jul 09, 2007 11:04 am

You can use SORT to get the count

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

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

madlui56 · Posted: Mon Jul 09, 2007 11:05 am

how about if it is on tape or mean tape files?
is is ok to use fileaid coz it is issuing a " file not on dasd message"

Thanks

Devzee · Posted: Mon Jul 09, 2007 11:11 am

dick scherrer · Posted: Mon Jul 09, 2007 11:12 am

Hello,

When you post a question, you need to include the important information. Fileaid and other online tools typically do not process tapes.

Depending on which tape management system your organization uses, the record count may be available there - talk with your storage administration people.

madlui56 · Posted: Mon Jul 09, 2007 11:33 am

Thanks for the information guys..