View previous topic :: View next topic
|
Author |
Message |
hyuzen
New User
Joined: 10 Jul 2005 Posts: 58
|
|
|
|
Hi all,
How can find out the number of records in a ksds file. Here is define options of ksds file:
RECORG=KS,KEYLEN=9,KEYOFF=10489,LRECL=10512,BLKSIZE=0,
UNIT=3390,SPACE=(CYL,(1,1))
I would like to count how many records there are in the ksds file based on a particular key. The key is CON and its position starts at 4100.
Thanks in advance,
Hyuzen |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
If you just want to display the count, you can use this DFSORT/ICETOOL job:
Code: |
//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=... VSAM input file
//TOOLIN DD *
COUNT FROM(IN) VSAMTYPE(V) USING(CTL1)
//CTL1CNTL DD *
OPTION VLSCMP
INCLUDE COND=(4104,3,CH,EQ,C'CON')
/*
|
The count will be displayed in TOOLMSG. For example:
ICE628I 0 RECORD COUNT: 000000000000003 |
|
Back to top |
|
|
hyuzen
New User
Joined: 10 Jul 2005 Posts: 58
|
|
|
|
Hi Frank,
Thank you very much for your quick response.
Bye,
Hyuzen |
|
Back to top |
|
|
|