How to check whether dataset exists or not

ibmmainframesyntel

How to check wether dataset exists or not .

i have to execute my job.

It may contains 3 or two input file.

so, before executing the above step, I have to check wether the dataset exists or not, so that I can override my PROC according to that
either 2 or 3 input file.

superk

Ask yourself, how would you do this in TSO (TSO, not ISPF) if you needed to? The method would be the same.

ofer71 · Posted: Mon Feb 26, 2007 9:35 pm Post subject:

LISTDSI & SYSDSN are the methods for you.

O.

deepak.vl · New User Joined: 17 Feb 2007 Posts: 38 Location: Hyderabad

Have a step which tries to read the dataset, for which you want to check whether it exists.
Have 2 steps after this, one to execute if the step 1 fails and other when step 1 is successful.
Control the execution of Steps 2 & 3 by using either a COND or an IF-ELSE.
Something like this...

STEP1 EXEC ..... --> (will try to read the dataset)
STEP2 EXEC ......COND=(0,EQ) --> (this will assume there are 3 datasets)
STEP3 EXEC ......COND=(0,NE) --> (this will assume there are 2 datasets)

Thanks,
Deepak

dick scherrer · Posted: Tue Feb 27, 2007 12:00 am Post subject:

Hello,

If step1 "tries to read" and the dataset does not exist, there will not be a recurn-code issued - the job will fail with a jcl error with the information that the dataset does not exist.

Please refer back to the post from superk. You need to verify existence before a step is executed with a dd statement that references the dataset which may or may not exist..

deepak.vl · New User Joined: 17 Feb 2007 Posts: 38 Location: Hyderabad

dick scherrer · Posted: Tue Feb 27, 2007 1:11 am Post subject:

Hi Deepak,

It is not elegant, but the way i used to check for a dataset (in batch) was to run an IDCAMS/LISTCAT for the dataset in question. If the LISTCAT is successful, IDCAMS sets a zero RC. If the LISTCAT fails, it is non-zero. Testing the return code would be like your suggestion above. The only real difference is that i specify the dsn to a utility and not to a DD statement.

After years of this, i decided that i would make sure the file(s) were always on the system. If there was no data, the file would only have an end-of-file and raise the AT END condition on the first read.

I liked this approach better than doing some kind of dance to use or not use a file that may or may not be cataloged.

deepak.vl · New User Joined: 17 Feb 2007 Posts: 38 Location: Hyderabad

Thanks Dick

dick scherrer · Posted: Tue Feb 27, 2007 9:18 am Post subject:

You're welcome

superk

Sigh.

So much for trying to get someone to think through the problem and arrive at a solution for themself.

We can't keep spoon-feeding everyone, folks.

dick scherrer · Posted: Tue Feb 27, 2007 9:11 pm Post subject:

Actually, my mission with that last bit of info was to "air" my preference that "checking for existence" need not be an issue if the design ensures that is an e-o-f when there is no data for the file. It is at least as easy to ensure there is an empty file as it is to check for existence and code around that (IMHO).

I agree that it would be excellent if there was a way to get folks to do some research/attempt, explain what they've researched/tried, and then post where they are stuck, Then we could help.

Answers are sometimes nice, but becoming self-sufficient is far more valuable.

We can only hope.

ibmmainframesyntel · Posted: Thu Mar 01, 2007 8:33 pm Post subject:

ibmmainframesyntel

ibmmainframesyntel · Posted: Thu Mar 01, 2007 8:43 pm Post subject:

hi people.........
give a good solution........
it will be more helpful for me....

can we use symbolic parameter in the control statement

superk · Posted: Thu Mar 01, 2007 8:47 pm Post subject:

William Thompson

superk

The best thing for you to do is, of course, use a PARM:

William Thompson · Posted: Thu Mar 01, 2007 8:51 pm Post subject:

ibmmainframesyntel

superk

Let me try to illustrate:

Let's say your job looks like this: