Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to know the number of records within a dataset

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
madlui56
Currently Banned

New User


Joined: 08 Aug 2006
Posts: 61
Location: Philippines

PostPosted: Mon Jul 09, 2007 10:36 am    Post subject: How to know the number of records within a dataset
Reply with quote

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.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Jul 09, 2007 10:52 am    Post subject:
Reply with quote

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".
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Mon Jul 09, 2007 10:55 am    Post subject:
Reply with quote

Using FILEAID you can get the record count without opening the file.
Back to top
View user's profile Send private message
madlui56
Currently Banned

New User


Joined: 08 Aug 2006
Posts: 61
Location: Philippines

PostPosted: Mon Jul 09, 2007 10:57 am    Post subject: Fileaid?
Reply with quote

Where specifically on fileaid or on what command?
Thanks.
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Mon Jul 09, 2007 11:01 am    Post subject:
Reply with quote

Option 3, and then 8
Quote:
Interactive Utility

give dataset name
and press enter
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1288
Location: Chennai, India

PostPosted: Mon Jul 09, 2007 11:04 am    Post subject: Re: dataset records?
Reply with quote

You can use SORT to get the count

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

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/
Back to top
View user's profile Send private message
madlui56
Currently Banned

New User


Joined: 08 Aug 2006
Posts: 61
Location: Philippines

PostPosted: Mon Jul 09, 2007 11:05 am    Post subject: file not on dasd message in FILEAID
Reply with quote

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
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Mon Jul 09, 2007 11:11 am    Post subject:
Reply with quote

Quote:
how about if it is on tape or mean tape files?

Use SORT
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Jul 09, 2007 11:12 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
madlui56
Currently Banned

New User


Joined: 08 Aug 2006
Posts: 61
Location: Philippines

PostPosted: Mon Jul 09, 2007 11:33 am    Post subject: Thanks..
Reply with quote

Thanks for the information guys..
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Browse dataset cvnlynn CLIST & REXX 4 Tue Jul 18, 2017 3:52 am
No new posts Fileaid 2 commands instream work. In ... descann Compuware & Other Tools 2 Tue May 16, 2017 3:31 pm
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts SMTP the current generation number of... Jyothi Kulunde JCL & VSAM 4 Thu May 04, 2017 4:08 pm
No new posts To find out size allocated to a seque... ashek15 JCL & VSAM 15 Thu Apr 27, 2017 9:42 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us