How to get the number of records in a file with out opening

sai.dara · New User Joined: 24 Aug 2007 Posts: 12 Location: Hyderabad

Hi Friends,

Good Morning!

I am in need of getting the number of records in a file. But I do not have access to open the file. Can I get the exact count using REXX or IBM SYS tables or VTOC data.

I could retrieve the Block size, space used, space allocated using REXX.

In the same way can I get the exact record count ?

Thanks in advance,

thanks and Regards,
sai

Succor · Posted: Tue Mar 24, 2009 12:48 pm

Sai,I dont think you would be able to achieve it without opening and reading the file.
Go through this link ,it might help:
www.ibmmainframes.com/post-36072.html

WTF

ofer71 · Posted: Tue Mar 24, 2009 1:17 pm

You can write an algorithm to calculate the number of records in a sequential dataset based on it's attributes: LRECL, BLKSIZE, %USED etc. However, this won't work for all cases, and it's pretty complex to achieve.

O.

dbzTHEdinosauer · Posted: Tue Mar 24, 2009 2:25 pm

if you don't have authority to access the file, why are you doing record counts?

diwa_thilak · Posted: Wed Mar 25, 2009 2:07 am

Sai,

You can check the below links

Count number of Lines in a file
Finding number of records

if the file is of high volume i would not recommend to use REXX/CLIST.

Please use the search button in the forum, you will find similar posts answered earlier.

MBabu · Posted: Wed Mar 25, 2009 9:39 am

in 99.999+% of the cases, there is no way to do this accurately without reading the data sets. You might be able to do this for fixed block standard (FBS) data sets if you can be assured that there are no short blocks, but the last block is almost always short. DS1LSTAR (part of the DSCB) might help with that, but since almost no one uses FBS data sets, I doubt that even matters.