View previous topic :: View next topic
|
Author |
Message |
subbprem
New User
Joined: 20 Apr 2005 Posts: 9 Location: Chennai
|
|
|
|
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 |
|
|
brain_s390
New User
Joined: 06 May 2005 Posts: 58 Location: Mumbai
|
|
|
|
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 |
|
|
mac1959
New User
Joined: 27 Jul 2005 Posts: 1
|
|
|
|
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 |
|
|
nallapureddy
New User
Joined: 27 Jul 2005 Posts: 18
|
|
|
|
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 |
|
|
dhiva_karanb
New User
Joined: 25 Aug 2005 Posts: 2
|
|
|
|
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 |
|
|
radhakrishnan82
Active User
Joined: 31 Mar 2005 Posts: 435 Location: chennai, India
|
|
|
|
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 |
|
|
spanda
New User
Joined: 31 Aug 2005 Posts: 48 Location: U.K.
|
|
|
|
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 |
|
|
nuthan123
New User
Joined: 06 Jun 2006 Posts: 4
|
|
|
|
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 |
|
|
kutty.r
New User
Joined: 22 Jun 2006 Posts: 24
|
|
|
|
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 |
|
|
neelesht
New User
Joined: 24 Jul 2006 Posts: 99 Location: Los Angeles
|
|
|
|
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 |
|
|
|