IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to read record count thru REXX


IBM Mainframe Forums -> CLIST & REXX
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
amitrath

New User


Joined: 30 Apr 2004
Posts: 28
Location: Carmel, USA.

PostPosted: Mon Apr 03, 2006 8:31 pm
Reply with quote

Hello everyone,

Can anyone tell me how to get the record count of any dataset (whatever dataset type, including VSAM) using rexx. I do not want to open/read the dataset. Is there any variable (say in LISTDSI) where I can read this data.

No code required. Give me the key-word. Thanks in advance.
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Mon Apr 03, 2006 8:36 pm
Reply with quote

amitrath wrote:
Is there any variable (say in LISTDSI) where I can read this data.


Nope, unless the dataset is a PDS, in which case you can get the "size" value from the ISPF statistics of the member.
Back to top
View user's profile Send private message
amitrath

New User


Joined: 30 Apr 2004
Posts: 28
Location: Carmel, USA.

PostPosted: Mon Apr 03, 2006 11:59 pm
Reply with quote

Thanks Superk for your prompt reply !

If you mean SPACE by 'size', then yes, we can get it from ISPF variables. But ISPF also shows the 'number of records' for any particular dataset in the panels (say =3.4). Is there any way I can find out where does this data come from? ISPF cannot be counting the lines. May be from some ISPF variable?

Thanks again.
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Tue Apr 04, 2006 2:24 am
Reply with quote

amitrath wrote:
But ISPF also shows the 'number of records' for any particular dataset in the panels (say =3.4).


No, it doesn't.
Back to top
View user's profile Send private message
amitrath

New User


Joined: 30 Apr 2004
Posts: 28
Location: Carmel, USA.

PostPosted: Tue Apr 04, 2006 4:44 am
Reply with quote

May be you are right. ISPF displays the number of records only in case of PDS.

Can you please tell where does this data comes in case of a PDS?
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Tue Apr 04, 2006 7:03 pm
Reply with quote

All of that information is retained in the PDS directory.
Back to top
View user's profile Send private message
martin9

Active User


Joined: 01 Mar 2006
Posts: 290
Location: Basel, Switzerland

PostPosted: Tue Apr 04, 2006 7:39 pm
Reply with quote

hy amitrath,

for a ps-file, if you need the exact number of records,
you have to open and read it.

for a pds-file, with SYSDSN you can get the number of members included
in the pds-file SYSMEMBERS, there is a possibility with ispf statistics data, but this won't be available in any case. to be sure you can force the statistics
with ispf-service LMMSTATS...

martin9
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CLIST & REXX

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 8
No new posts Running REXX through JOB CLIST & REXX 13
No new posts Error to read log with rexx CLIST & REXX 11
No new posts To get the count of rows for every 1 ... DB2 3
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
Search our Forums:

Back to Top