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

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

0 Answers  


Step 1 RC 4 Step 2 Step 3 I want to know the COND parameter which can be coded in step 2 or 3. Step 2 should be executed based on Step 1 RC and Step 3 should not be executed based on step 1's RC

0 Answers  


In My job I have 15 procs.and in each proc i have 3 steps. i want to execute 3 step in proc 10.is it possible? if possible how?

2 Answers   HP,


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.

5 Answers   CTS,


if we want to use a gdg which is already created by some job, then how to use the reference of the last generation in a jcl?

0 Answers   IBM,


what is mainframe?

4 Answers   CGI,


what are the symbolic parameters? why do we use symbolic parameters ?

2 Answers   IBM, TCS, UST, Xansa,


Explain how can an in-stream dataset be terminated?

0 Answers  


Hi, all Suppose i have 10 step in a job (s1,s2,s3,...s10) i want to execute step9 first and then step3 and i used the DPRTY for these steps. so what will happen to other steps? Will the get executed or only these two steps get executed?

2 Answers  


In order to continue a job after a return code of 12 in step1, what the step2 exec statement include?

1 Answers  


I have 15 flat files. each record in the files have the monthly salary for 12 months with the employee number. Now I want to concatenate the 15 files such that for the employee numbers that are common the o/p file should have only one record and the salaries should be concatenated to that record. How can we do it with JCL?

1 Answers  


Is it possible to define dd statements as you want?

0 Answers  


Categories