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
 

 

To see the number of records in vsam file using FILEAID

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
subbprem

New User


Joined: 20 Apr 2005
Posts: 9
Location: Chennai

PostPosted: Mon Jul 04, 2005 1:20 pm    Post subject: To see the number of records in vsam file using FILEAID
Reply with quote

Is there any option in file-aid to see the number of records in vsam file without opening the file?

Thanks and Regards,
Back to top
View user's profile Send private message

brain_s390

New User


Joined: 06 May 2005
Posts: 58
Location: Mumbai

PostPosted: Mon Jul 04, 2005 8:31 pm    Post subject: Re: File-aid.
Reply with quote

Hi,

I dont think F.3.5 will show you the no of records.It only displays cluster name,data component,index component,dataset type,space info etc.

Experts can you pls throw some light on this !
Back to top
View user's profile Send private message
mac1959

New User


Joined: 27 Jul 2005
Posts: 1

PostPosted: Wed Jul 27, 2005 4:53 am    Post subject: Fileaid
Reply with quote

Is there a way to copy the member list only from one dataset to another dataset with Fileaid? I know you can do a table print online and send it to a dataset, however, I would like to do this through JCL. Thanks.
Back to top
View user's profile Send private message
nallapureddy

New User


Joined: 27 Jul 2005
Posts: 18

PostPosted: Wed Jul 27, 2005 9:43 am    Post subject:
Reply with quote

you can view the number of records in a file (with out opening it) using 3.5 option in file-aid.Give the file name in 3.5 option and press control twice
it will give the details about the number of records,i.e total number of records existing,no of records inserted and deleted also
Back to top
View user's profile Send private message
dhiva_karanb

New User


Joined: 25 Aug 2005
Posts: 2

PostPosted: Thu Aug 25, 2005 11:18 am    Post subject:
Reply with quote

Dear subbprem,
-At present i doesn't have idea about FILE-ID tool
- pls send the details and important concept of FILE-ID tool

(email id) ******Email Id Deleted******
wating for ur reword
by
dhiva
Back to top
View user's profile Send private message
radhakrishnan82

Active User


Joined: 31 Mar 2005
Posts: 436
Location: chennai, India

PostPosted: Thu Aug 25, 2005 4:06 pm    Post subject:
Reply with quote

Adding one more way to the FILE-AID cap,

We have a file-id with interactive utility option.
The comman TALLY is issued to see the number of records
[left]
F I L E - A I D V8.8.2 RELEASE DATE 04/01/02
....ENTER NEXT FUNCTION OR END
TALLY
SYS00155 DSN=ACMSTMP.WQAN.WQAB07A OPENED AS PS,
RECFM=FB,LRECL=231,BLKSIZE=27951,VOL=QP3073
ABOVE FUNCTION ENDED ON NORMAL EOD RC=0
RECORDS-READ=17

....ENTER NEXT FUNCTION OR END[/left]
Back to top
View user's profile Send private message
spanda

New User


Joined: 31 Aug 2005
Posts: 48
Location: U.K.

PostPosted: Thu Sep 01, 2005 9:13 pm    Post subject: Re: To see the number of records in vsam file using FILEAID
Reply with quote

Using the File-Aid 3.5 option and hitting Enter twice will give you the number of records, provided it is a VSAM KSDS file. This number appears, labelled as 'Prime Records'. For PS files it doesn't work.

For PS files, try using the Interactive option (3.8) option of the File-Aid utility. See prev post from Radhakrishnan82 for details.

Personally, I use a REXX utility called COUNTX to find the number of records from the DSLIST (3.4) panel. This works as a line command just by typing COUNTX by the side of the dataset name. This utility was available in one of the cbttape files (think it was cbt#357), which had loads of ISPF utilities.

Cheers,
Panda.
Back to top
View user's profile Send private message
nuthan123

New User


Joined: 06 Jun 2006
Posts: 4

PostPosted: Tue Jun 06, 2006 3:34 pm    Post subject: records count from file-aid
Reply with quote

Hi,

U can use tally command in file-aid

goto 3 utilities
and go to 8 interactive
give dataset -- enter
give tally command
it gives the count ..
regards
Nuthan Reddy Muppidi.
Back to top
View user's profile Send private message
kutty.r

New User


Joined: 22 Jun 2006
Posts: 24

PostPosted: Wed Jul 26, 2006 2:00 pm    Post subject: no of record
Reply with quote

to see the no of records

option no 3.8 . 1.give the file name ( optionally u can give the o/p data set name in which u can see the result)

2. then on the command line give TALLY
3. then u can see the result immediately or in the o/p data set if give one

u can also give conditions such as an field has repeated how mant times
to find that give tally=if ( position,c'sger777')go

if u give this u can find how many times 'sger777' occured in that particular field
Back to top
View user's profile Send private message
neelesht

New User


Joined: 24 Jul 2006
Posts: 99
Location: Los Angeles

PostPosted: Wed Jul 26, 2006 6:53 pm    Post subject:
Reply with quote

Utilities --> VSAM -->DATASET NAME and then hit enter twice, all the information ragarding the VSAM file.

Works only for VSAM KSDS file.
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 -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 2 Fri Mar 24, 2017 3:25 pm
No new posts splitting a file abdulrafi DFSORT/ICETOOL 4 Fri Mar 24, 2017 11:51 am
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Formatting VB File Learncoholic DFSORT/ICETOOL 3 Mon Mar 20, 2017 12:29 pm


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