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

restart logic ?

2 Answers   TCS,


If Name is NOT given for a JOB statement, then will it give error or installation will supply it for the JOB ?

1 Answers   IBM,


How to create delta file using JCL

1 Answers   CTC,


WORKING-STORAGE SECTION. 1 GROUP-ITEM. 05 AMOUNT-1 PIC 99V9 USAGE COMP VALUE 50. 05 AMOUNT-2 PIC 9(4)V99 USAGE COMP. PROCEDURE DIVISION. MOVE ZERO TO GROUP-ITEM. ADD 50 TO AMOUNT-1. DISPLAY AMOUNT-1. STOP RUN.

1 Answers  


what disp parameter we mention for creation of temporary dataset so that we can use it in later steps?

0 Answers   IBM,


how do u see jobs submitted before ur job ?

1 Answers  


What is the differentiation between TRK,cyl, and Bytes... how they can be connected??

2 Answers  


What are some jcl statements that are not allowed in procedures?

0 Answers  


Can we write same stepname for one or more steps in on job ?

2 Answers  


If job is submitted with typerun = hold then how can we submit the same job?

3 Answers   Wipro,


what's the significance of freespace(0 0) and freespace(100 100)

3 Answers  


We have two PS files,want to compare those files and put the duplicate records in one file. Input file 1 contains(1,2,4,9,10) Input file 2 contains (1,4,5,11,12,14,16). Help me with jcl.

6 Answers  


Categories