How to override a File name in PROC

sukumar.pm · New User Joined: 20 Dec 2007 Posts: 27 Location: chennai

I have a db2 program in my proc. That db2 program uses a file OLESON. I want to override that file OLESON from my JCL.

I've tried with the following.

superk · Posted: Sat May 24, 2008 9:29 pm

Your code looks correct.

//PROCSTEPNAME.DDNAME DD ....

is the correct way to code a DD override.

If STEP080 is the PROC STEPNAME and B6505I4 is the DD name, your override should be working properly.

sukumar.pm · New User Joined: 20 Dec 2007 Posts: 27 Location: chennai

thank you for your reply..

if the file is being used in the non db2 program,my jcl gently overrides the file.in my case, it is a DB2 program.so endup in a jcl error.the error is step080 is not found.

gcicchet · Posted: Mon May 26, 2008 8:13 am

Hi,
can you show the proc or job output from failed job.

Gerry

ksk · Posted: Mon May 26, 2008 11:17 am

Hi All,

I am posting my problem in the same post instead of starting new one am also facing the same probelm.

I have also faced the same situation in case of DB2 program. I am using DSNUPROC utility in procedure and the DD name was used in proc was DSNUPROC.SYSREC00.

I wanted to override this step from JCL. Stepname in PROC for DSNUPROC utility was LOADSTEP.

I have provided following statement in JCL to override.

//LOADSTEP.DSNUPROC.SYSREC00 DD DSN=...., DISP=...

But this JOB was giving JCL error by stating INVALID LABELNAME.

PROC looks like below.

gcicchet · Posted: Mon May 26, 2008 11:51 am

Hi,
as mentioned earlier, to over-ride a DDname in a procedure, you need to know the DDname and the step name in which it is used inside the procedure. When you code

//stepname.ddname DD ...

in your JCL, it causes JES to insert (add or over-ride) the DDname into
the specified step inside the PROC. The resulting merged JCL is placed
in the job queue and executed.

Gerry

superk · Posted: Mon May 26, 2008 12:09 pm

ksk, you need to review the rules for Nested Procedures.

It's not possible to do what you're attempting to do.

sri_mf · Active User Joined: 31 Aug 2006 Posts: 218 Location: India

Here is an example which i have tested and worked fine.

ksk · Posted: Mon May 26, 2008 12:32 pm

Hi Kevin,

Thanks very much for your information.

If I want to override this already overrode dataset thru JCL, is there any other way to do it?

Because I don't want change the PROC whcih has DSNUPROC.SYSREC00 statement. I want to override this dataset with my own dataset in JCL and test it.

KSK

dick scherrer · Posted: Mon May 26, 2008 7:57 pm

Hello,

Sri -
how does your jcl relate to the question? What you posted is rather "normal" and works many places. The "problem" is not like your solution. . .

KSK -
You might consider a test proc of the same name and put it in a different proclib for your testing.

ksk · Posted: Tue May 27, 2008 8:38 am

Dick,

Thanks for the solution.

Sri,

Your solution is for normal cases but my requirement is different and override is not possible in my case as explained by Kevin.

Thanks,
KSK

dick scherrer · Posted: Tue May 27, 2008 9:07 am

You're welcome

d

sri_mf · Active User Joined: 31 Aug 2006 Posts: 218 Location: India

dick scherrer · Posted: Tue May 27, 2008 9:20 pm

Hello Sri,

Not a problem

Misunderstandings do happen and we try to follow up.

d

sukumar.pm · New User Joined: 20 Dec 2007 Posts: 27 Location: chennai

hi all,
thanks for ur reply.

To override the file which is used in the non-db2 program in the PROC,

put this in JCL,
//PROCSTEPNAME.DDNAME DD DSN=<DATASET NAME>

it works fine.it overrides the file given in the PROC.

To override the file which is used in the db2 program in the PROC,

put this in JCL,
//PROCSTEPNAME.DB2BATCH.DDNAME DD DSN=<DATASET NAME>

try this..this might be working.

Thanks!
Sukumar

sukumar.pm · New User Joined: 20 Dec 2007 Posts: 27 Location: chennai

Hi KSk,

i think we should not directly use DSNUPROC.you take any job which ran successfully.after the run,you will be getting the expanded JCL in the spool.you try to get the stepname from corresponding utility you used to execute. that stepname should be used instead of DSNUPROC..

try this..

Sukumar