View previous topic :: View next topic
|
Author |
Message |
rikdeb
New User
Joined: 19 Jan 2009 Posts: 63 Location: hyderabad
|
|
|
|
Hi All...I have the JCL to get count of records of one file and write onto a dataset.
like
//SORTIN DD DSN=TEST.SORT.INPUT,DISP=SHR
//SORTOUT DD DSN=output.dataset
//SYSIN DD *
SORT FIELDS=(1,3,CH,A)
OUTFIL REMOVECC,NODETAIL,
TRAILER1=('NO:',COUNT=(M11,LENGTH=8))
Is there a way to include count of multiple files into one Output file instead of writing the same JCL for every input file.
like below:
No of records in F1: 4
No of records in F2: 5
etc... |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Why do you want to do that? There is a cost associated with processing files. Your client happy with you just adding to that to get some counts?
Have a look at ICETOOL's COUNT operator. |
|
Back to top |
|
|
rikdeb
New User
Joined: 19 Jan 2009 Posts: 63 Location: hyderabad
|
|
|
|
No.. thing is i have 4 files.. i need to take the counts from 4 files and put in single file to generate report havng counts of all files. I need to use SYNCSORT in my jcl. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
rikdeb,
Syncsort's SYNCTOOL supports DFSORT's ICETOOL COUNT operator. It can very well work on 4 input files and write the counts into a single output file.
Did you follow Bill's suggestion above? |
|
Back to top |
|
|
rikdeb
New User
Joined: 19 Jan 2009 Posts: 63 Location: hyderabad
|
|
|
|
Hi arun.. I didnt get the chance to run with sycntool. I wil defntly run and post here if it works for me.. |
|
Back to top |
|
|
|