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 Unable to catalog a gdg dataset resid... Shovan JCL & VSAM 3 Fri Mar 24, 2017 2:24 pm
No new posts Want to pull the job log into a Mainf... Jishu Mukherjee Compuware & Other Tools 9 Tue Mar 21, 2017 4:48 pm
No new posts what is meaning of the number in dcl Martylin PL/I & Assembler 2 Thu Mar 09, 2017 7:18 am
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am


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