How to find out the number of records in a file using JCL
Answers were Sorted based on User's Feedback
Answer / logeshwaran
//COUNT EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=INPUT DATASET,
// DISP=SHR
//TOOLIN DD *
COUNT FROM(IN)
/*
Is This Answer Correct ? | 18 Yes | 0 No |
Answer / mohanasundaram
step1 exec pgm=idcams
sysprint dd sysout=*
sysout dd sysout=*
infile dd dsn=filename,disp=shr
sysin dd *
print(filename)-
count(3)
/*
//
In input file 3 records is there means it will be show maxcc=0 else it will show maxcc=4
Is This Answer Correct ? | 6 Yes | 0 No |
Using Syncsort,
//SORT1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=Input.File,DISP=SHR
//SORTOUT DD DSN=Output.File,...
//SYSIN DD *
SORT FIELDS=COPY
OUTFIL FILES=OUT,TRAILER1=
(1:COUNT),REMOVECC,NODETAIL
/*
This job creates a report with a single trailer record
containing the record count.
The COUNT subparameter of TRAILER1 provides the number of
records for the entire report (all the records) starting at
position 1.
REMOVECC omits the ANSI carriage control character from all
of the report records.
NODETAIL generates a report with no data records, only
header and trailer records, as specified.
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / ravi
Logesh,
I'm not sure where the output (record count) is written to.
Can you let me know how to write it to spool & dataset.
My output should be:
Record count is: <count>
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / anilkumar
//COUNT EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=INPUT DATASET,
// DISP=SHR
//TOOLIN DD *
*option1
COUNT FROM(IN)
*Instead of count u can aslo use stats operator
*option2
stats from(IN) on(20,5,ZD)
*output will be available in spool ie.in toolmsg
/*
Is This Answer Correct ? | 0 Yes | 1 No |
how can we pass external data to instream procedures
5 Answers IBM, Infosys, Ocwen,
How does jcl specify the job to the operating system?
How many types we can give input to JCL
I've one sequential file, That file contains millians of Junk & CHAR recoreds example File 1 ,,,,,...,,,.....,.,.INFOSYS.....,,,,,,,,,,,WIPRO..........., ,...,..,. My questions is : I want omit the 44th posstion to 4 CHAR (WIPRO) remaining things I want output file (including Junk CHAR also)... How can we slove this problem & give me a syntax. Please provide the result as soon as possible.
What happens if both JOBLIB & STEPLIB is specified ?
How to pass the parameter in parm using linkage section ? (syntax)?
what is a steplib
How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.
Can we delete the data using IEFBR14 , IEBGENER??
how to identify a vasam dataset by seeing in 3.4(browse)
I HAVE A SEQUENTIAL FILE CONTAINING ONE RECORD IN WHICH I HAVE ONE FIELD AS CUSTOMER IDENTITY NUMBER FIELD WHICH IS A SIGNED FIELD. HOW TO SEQUENTIALLY INCREMENT THIS FIELD USING OVERLAY PARAMETER?.
Can anybody tell what is tool used to generate the list of PROCS used in JCL to generate a PROCTREE