Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How to find out the number of records in a file using JCL

Answers were Sorted based on User's Feedback



How to find out the number of records in a file using JCL..

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

How to find out the number of records in a file using JCL..

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 ?    7 Yes 0 No

How to find out the number of records in a file using JCL..

Answer / srinivasa gudla

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

How to find out the number of records in a file using JCL..

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

How to find out the number of records in a file using JCL..

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

Post New Answer

More JCL Interview Questions

which parameter is used to check the syntax of a jcl without executing it?

0 Answers   IBM,


How to concatenate different LRECL of files?

2 Answers   IBM,


IF we are calling a PROC from Jcl...This Proc have 3 steps in it and we want to execute only the second step using the JCL, How to do it?? Please give the answer ASAP:)

8 Answers  


What is the use of ikjeft1b utility in jcl?

1 Answers  


Hi, can we call catalog( say myproc } proc n times in jcl if so how please explain Thanks in advance

2 Answers   Cap Gemini,


List the various advantages of using jcl language?

0 Answers  


whats the diff bw the evaluate also and and?

0 Answers   CGI,


Explain about CBL/PROCESS statement syntax

1 Answers  


What is DYNAMBR in jcl?

2 Answers   CTS,


What is the syntax of JCL statement?

0 Answers  


AM HAVING A FILE WHICH CONTAIN 12 DATS OUT OF WHICH 4 ARE DUPLICATES HOW TO REMOVE THE DUPLICATE FILES IN JCL? CAN I GET THE PROGRAM FOR THIS

3 Answers  


How to find in aparticular step how many versions a paricular gdg base have?

4 Answers   TCS,


Categories