Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to read record count thru REXX

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
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    Post subject: How to read record count thru REXX
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

Moderator Team Head


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

PostPosted: Mon Apr 03, 2006 8:36 pm    Post subject: Re: How to read record count thru REXX
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    Post subject: Re: How to read record count thru REXX
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

Moderator Team Head


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

PostPosted: Tue Apr 04, 2006 2:24 am    Post subject: Re: How to read record count thru REXX
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    Post subject: Re: How to read record count thru REXX
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

Moderator Team Head


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

PostPosted: Tue Apr 04, 2006 7:03 pm    Post subject: Re: How to read record count thru REXX
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> CLIST & REXX All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts query to fetch record which has only ... maxsubrat DB2 12 Mon Dec 11, 2017 5:03 pm
No new posts Looping REXX - unable to interrupt RAVISANKAR07 CLIST & REXX 3 Wed Dec 06, 2017 1:08 pm
No new posts The same REXX program doesnt work for... jackzhang75 CLIST & REXX 5 Wed Dec 06, 2017 2:51 am
No new posts ISMF Difference between volume count ... upendrasri IBM Tools 2 Tue Dec 05, 2017 12:40 pm
No new posts Rexx - File tailoring samzee71 CLIST & REXX 10 Thu Nov 30, 2017 10:47 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us