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 test thru JCL if any file(PS or VSAM) is empty or
not. I do not want to use any COBOL prog or Ezytrieve and
want to do using utility.

Answers were Sorted based on User's Feedback



How to test thru JCL if any file(PS or VSAM) is empty or not. I do not want to use any COBOL prog ..

Answer / vani

By IDcams its is possible
// STEP EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//FILE1 DD DSN=INPUT-FILE,DISP=SHR
//SYSIN DD *
PRINT INFILE(FILE1)
DUMP COUNT(1)
/*
IF THE FILE IS EMPTY JCL GIVES RC=4

Is This Answer Correct ?    21 Yes 6 No

How to test thru JCL if any file(PS or VSAM) is empty or not. I do not want to use any COBOL prog ..

Answer / ram g

u can use ams command repro thru idcams utility and check
for rc

Is This Answer Correct ?    19 Yes 5 No

How to test thru JCL if any file(PS or VSAM) is empty or not. I do not want to use any COBOL prog ..

Answer / naren

IFEMPTY utility is used to check the file is empty or not,
if the return code of this step is 4 then the file is empty.

Is This Answer Correct ?    15 Yes 5 No

How to test thru JCL if any file(PS or VSAM) is empty or not. I do not want to use any COBOL prog ..

Answer / ekluba

With proper Syntax answer #5 is correct:

//SYSPRINT DD SYSOUT=*
//DD1 DD DSN=???.EMPTY,DISP=SHR
//SYSIN DD *
PRINT INFILE(DD1) COUNT(1)
/*

Is This Answer Correct ?    9 Yes 2 No

How to test thru JCL if any file(PS or VSAM) is empty or not. I do not want to use any COBOL prog ..

Answer / suga

you can use IEBPTPCH utility.it is used to check whether it
is empty or not.If the return code is 4 then the file is
empty.

Is This Answer Correct ?    10 Yes 4 No

How to test thru JCL if any file(PS or VSAM) is empty or not. I do not want to use any COBOL prog ..

Answer / deb

First SORT the input file.
Assume the sorted o/p is in MY.SORT.FILE, then run this step

//CHEKEMTY EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//MYFILE DD DSN=MY.SORT.FILE,DISP=SHR
//SYSIN DD *
PRINT INFILE(MYFILE) CHARACTER COUNT(1)

if the above step returns a RC=4, then the file is
empty

Is This Answer Correct ?    10 Yes 5 No

How to test thru JCL if any file(PS or VSAM) is empty or not. I do not want to use any COBOL prog ..

Answer / nagendra

Hi vani,

When i tried executing ur JCL i am getting this error while
giving JJ.

'DUMP' IS NOT A RECOGNIZED IDCAMS STATEMENT NAME

What shall i do????

Is This Answer Correct ?    5 Yes 2 No

How to test thru JCL if any file(PS or VSAM) is empty or not. I do not want to use any COBOL prog ..

Answer / guruprasad

print command

Is This Answer Correct ?    2 Yes 1 No

How to test thru JCL if any file(PS or VSAM) is empty or not. I do not want to use any COBOL prog ..

Answer / manid

//STEP1 EXEC PGM=IDCAMS
//DD1 DD DSN=FILE1
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
PRINT INFILE(DD1) COUNT(*)
/*

IF STEP1 RETURNS RC=4 THEN FILE1 IS EMPTY FILE

I HOPE THIS WILL HELP YOU

Thanks
ManiD

Is This Answer Correct ?    3 Yes 4 No

How to test thru JCL if any file(PS or VSAM) is empty or not. I do not want to use any COBOL prog ..

Answer / sivakumar

Use comparex/ISRSUPC utility and compare ur file with an
empty file of the same DCB parameter. Retrun code of 28
means the file is empty. return code of 1 means the file is
not empty.

Is This Answer Correct ?    5 Yes 7 No

Post New Answer

More JCL Interview Questions

a jcl has 2 steps. How to code the jcl such that if step1 abends, then step2 runs. Else, job terminates with step1?

1 Answers   IBM,


if we have a job consist of two steps and each step calling a proc having 10 steps each then how many steps are counted only 2 or 22(10+10+1+1)? can we have more than 255 steps in a single job?

5 Answers   Accenture,


Explain the hierarchy levels in jcl?

0 Answers  


in a series of 10 steps, i need to run only 1,3,5,7 & 9th steps only. how do u code?

5 Answers   ADP,


What is the meaning of the EXEC statement keyword, COND? What is its syntax?

2 Answers  


Explain how can return codes be tested before execution of a job step?

0 Answers  


which utility is used to update pds?

1 Answers   IBM,


i have 1000 records in input file and i want to sort it and the first 200 records to be placed in output file. how to do that??

14 Answers   L&T,


How is a dataset passed from one step to another?

2 Answers   DELL,


When will we need to specify Space parameter ?

3 Answers   Wipro,


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 pass data to a program that is coded in an exec statement?

0 Answers  


Categories