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

how to count no of records in VSAM cluster


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
manikant pathak

New User


Joined: 09 May 2005
Posts: 37
Location: bangalore

PostPosted: Tue Jun 14, 2005 3:57 pm
Reply with quote

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
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Tue Jun 14, 2005 9:21 pm
Reply with quote

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
View user's profile Send private message
David P

Active User


Joined: 11 Apr 2005
Posts: 106
Location: Cincinnati Ohio

PostPosted: Wed Jun 15, 2005 9:52 am
Reply with quote

Hi,
You can also use LISTCAT for counting the number of records.

regards,
David.
Back to top
View user's profile Send private message
manikant pathak

New User


Joined: 09 May 2005
Posts: 37
Location: bangalore

PostPosted: Wed Jun 15, 2005 11:36 am
Reply with quote

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
View user's profile Send private message
Alain Benveniste

New User


Joined: 14 Feb 2005
Posts: 88

PostPosted: Wed Jun 15, 2005 6:29 pm
Reply with quote

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
View user's profile Send private message
manikant pathak

New User


Joined: 09 May 2005
Posts: 37
Location: bangalore

PostPosted: Wed Jun 15, 2005 7:04 pm
Reply with quote

hi ,


thanks all for replying to my query....




bye,

MKP
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts To get the count of rows for every 1 ... DB2 3
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
No new posts To find whether record count are true... DFSORT/ICETOOL 6
Search our Forums:

Back to Top