Hi
I need to calculate number of records in a dataset by running a JCL. Can any one let me know the JCL
Thanks in advanced
need to Count number of records
-
- Posts: 18
- Joined: Wed Mar 26, 2008 1:04 pm
- Skillset: JCL,COBOL,DB2,CICS
- Referer: From www.google.com
- dick scherrer
- Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
Re: need to Count number of records
Hello,
Try this:
or this:
Try this:
Code: Select all
//COUNT EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//DD01 DD DSN=FILE_NAME,
// DISP=SHR
//TOOLIN DD *
COUNT FROM(DD01)
/*
or this:
Code: Select all
//COUNT EXEC PGM=FILEAID,REGION=6M
//STEPLIB DD DISP=SHR,DSN=YOUR.FILEAID.LINKLIB
//SYSPRINT DD SYSOUT=*
//SYSLIST DD SYSOUT=*
//DD01 DD DSN=FILE_NAME,
// DISP=SHR
//*
//SYSIN DD *
$$DD01 TALLY
/*
Hope this helps,
d.sch.
d.sch.
-
- Posts: 18
- Joined: Wed Mar 26, 2008 1:04 pm
- Skillset: JCL,COBOL,DB2,CICS
- Referer: From www.google.com
Re: need to Count number of records
Thanks!!! Dick, it works.... 

- dick scherrer
- Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
Re: need to Count number of records
You're welcome - thank you for posting that you have a solution
d

d
-
- Similar Topics
- Replies
- Views
- Last post
-
- 3
- 3717
-
by naveenkumar sudha
View the latest post
Mon May 09, 2022 10:15 pm
-
-
SUM and count of records by key, using SORT utility
by naveenkumar sudha » Mon May 09, 2022 10:11 pm » in DFSORT/ICETOOL/ICEGENER - 2
- 6541
-
by ssbylzh
View the latest post
Sat May 21, 2022 5:10 pm
-
-
-
Insert records from File1 between records of File2
by Daouchiche » Wed Nov 10, 2021 6:37 am » in DFSORT/ICETOOL/ICEGENER - 6
- 2342
-
by sergeyken
View the latest post
Thu Nov 11, 2021 12:43 am
-
-
- 1
- 2585
-
by engh
View the latest post
Thu Jun 22, 2023 5:35 pm
-
-
How To display the count based on a specific string?
by Chintu333 » Fri Aug 19, 2022 12:59 am » in DFSORT/ICETOOL/ICEGENER - 3
- 2112
-
by sergeyken
View the latest post
Fri Aug 19, 2022 8:52 pm
-