We are using 2 files , file one has data, file two is
empty.Using jcl how can we find the other file is empty?
Answers were Sorted based on User's Feedback
Answer / mchava
using IDCAMS utitlity
Print infile(file name) count(1)
it will check whether the file is empty or not
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / sundar
Using IDCAMS utility
In SYSIN:
PRINT(infile) COUNT(1)
If this step return 4 then the file is empty otherwise if
return 0 then the file is not empty.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / sham
using idcams and its command print we can find wheather the
fiel is empty or not
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / raghu
This can be done using ICETOOL.
//STEP1 EXEC PGM=ICETOOL
//IN DD DSN=……input file1
//TOOLMSGDD SYSOUT=*
//DFSMSG DD SYSOUT=*
//TOOLIN DD*
COUNT FROM(IN) EMPTY
/*
In the above JCL, Input file1 is empty. If we run this JCL
it will retrun NON-ZERO retrun code.
adv: It will be very helpful when we want to run some steps
after checking a particular file is empty or not.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / bala
Compare the file with another known empty file. IEBCOMPR
comparison of two empty files should give non empty RC.
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / vinay sonar
Print the contents of file using IDCAMS utility if it is
empty you will get MAXCC 4
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rajesh_m13
stepname exec vsamempt=yes
that shows empty file
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / deepak dada, jaipur
the handling would happen
if the file is empty then pass the zero to return code in
cobol program
then go to jcl step and check for the conditiom code( 0,
eq) where the program is getting called and do whatever you
want to do
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / deepak dada, jaipur
the handling would happen
if the file is empty then pass the zero to return code in
cobol program
then go to jcl step and check for the conditiom code( 0,
eq) where the program is getting called and do whatever you
want to do
| Is This Answer Correct ? | 0 Yes | 5 No |
What is DATACOM db?
How to resolve the error "WER488A JOIN CAPACITY EXCEEDED" I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem? I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem?
Can you delete the GDG base without deleting GDG generations ?
Is CPU time assigned to a JOB and JOBSTEP BOTH, by default ?
Suppose i have 2 steps in my pgm. Step1- creates a file, Step2 - generates report from file in step1, What changes have to be made in Step2, so that if the file in Step1 is empty Step2 should not be executed? No changes to be made to Step1.
how can handle the s0c4 abend???
how to allocate a dynamic dataset in jcl ?
can we modify the code in copy book? if it possible how to submit ofter the modification.
what is a null indicator in db2?
Suppose I have a file with three fields with data in the following format 1. empid - S9(4) COMP 2. empname - X(20) 3. empsal - S9(5)V(2) COMP-3 If I view this file, it will not be in a readable format. How to display the empid and empsal fields in a readable format without using COBOL program? What kind of SORT card will have to be coded?
What is the significance of addrspc parameter in exec statement?
what is DD statement is used in JCL?