View previous topic :: View next topic
|
Author |
Message |
manikant pathak
New User
Joined: 09 May 2005 Posts: 37 Location: bangalore
|
|
|
|
hi,
can anyone please tell me what is the utility used to count the no of records in a VSAM cluster...
Thanks in advance,
MKP |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Here are two ways to count the records in a VSAM cluster with DFSORT:
DFSORT/ICETOOL COUNT operator
Code: |
//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=... VSAM input file
//TOOLIN DD *
COUNT FROM(IN)
/*
|
The count will be displayed in TOOLMSG in a message like this:
Code: |
ICE628I 0 RECORD COUNT: 000000000000502
|
DFSORT OUTFIL COUNT
Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=... VSAM input file
//SORTOUT DD SYSOUT=*
//SYSIN DD *
OPTION COPY
OUTFIL NODETAIL,REMOVECC,
TRAILER1=(COUNT=(M11,LENGTH=5),80:X)
/*
|
The count will be displayed in SORTOUT. |
|
Back to top |
|
|
David P
Active User
Joined: 11 Apr 2005 Posts: 106 Location: Cincinnati Ohio
|
|
|
|
Hi,
You can also use LISTCAT for counting the number of records.
regards,
David. |
|
Back to top |
|
|
manikant pathak
New User
Joined: 09 May 2005 Posts: 37 Location: bangalore
|
|
|
|
hi Frank,
can you please explain the parameters given in count i.e M11 and length =5 ,why are you specifying length=5?
MKP |
|
Back to top |
|
|
Alain Benveniste
New User
Joined: 14 Feb 2005 Posts: 88
|
|
|
|
DFSORT gives you the opportunity to use many pre-defined edit masks. M11 is one of them.
LENGTH specifies the length of the edited output field. If the implied length of the edited output field produced using an edit mask or edit pattern is not suitable for presenting your numeric data, LENGTH can be used to make the edited output field shorter or longer. n specifies the length of the edited output field. The value for n must be between 1 and 44. LENGTH does not change the pattern used, only the length of the resulting edited output field.
Take a look to the DFSORT Application Programming Guide.
Alain |
|
Back to top |
|
|
manikant pathak
New User
Joined: 09 May 2005 Posts: 37 Location: bangalore
|
|
|
|
hi ,
thanks all for replying to my query....
bye,
MKP |
|
Back to top |
|
|
|