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

To see the number of records in vsam file using FILEAID


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
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
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
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
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
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
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: 435
Location: chennai, India

PostPosted: Thu Aug 25, 2005 4:06 pm
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
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 7
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Search two or more word with FILEAID Compuware & Other Tools 15
No new posts Access to non cataloged VSAM file JCL & VSAM 18
Search our Forums:

Back to Top