Accessing symbolic parameters

Vinay N.G · New User Joined: 15 Sep 2008 Posts: 36 Location: Bangalore

Part of DB2 unload JCL using BMC utility is pasted below, Here i am trying to get the value of opfle and TBNAME from keyboard during runtime through rexx.
Job completes with maxcc=0, but the output file is not getting created. I guess the value of OPFLE i.e SYSREC is not being passed to UNLDDS.
But after job completion we can see that the entered file name will be assigned to SYSREC.

Could anyone please let me know the reason for this.

// SET SYSREC=&OPFLE
//*SET CRITER=CIBCORP
//*
//UTIL0001 EXEC D2IBMCUP,
// CNTL='DUMMY,',
// SUBSYS=DB2T,
// UID=&SYSUID..TABLE,
//* RESTART='TERM',
// UNLDDS=&SYSREC.,
// DATACLS=HUGE
//SYSIN DD *
UNLOAD SELECT * FROM &TBNAME.

Thanks

dick scherrer · Posted: Thu Jan 29, 2009 11:12 am

Hello,

Do you have a set of JCL and control statements that work correctly when submitted from tso/ispf? If not, i would complete testing a batch stream that works correctly.

After the controlled test was successful, i would then look into working in rexx to finish the requirement.

How does this PROC expand?

Vinay N.G · New User Joined: 15 Sep 2008 Posts: 36 Location: Bangalore

Hi dick,
I have not pasted the complete JCL, its just a part of unload JCL.
Ofcource i mention the proc library in the beginning of the step.

As u said it works fine if i sumbit JCL directly without invoking it through REXX.

In that case i ll associate my PS to SYSREC which will be passed to the proc D2IBMCUP.

eg:// SET SYSREC=user.abcd.efgh

But if the same PS is accepted from keyboard during run time through rexx, its not being passed to the PROC i guess and hence the file is not getting created.

Please let me know what can be done for this.

dick scherrer · Posted: Fri Jan 30, 2009 1:49 am

Hello,

It may help if you post the rexx that receives the value from the user and show what is then generated in the jcl that gets submitted.

You might want to run that part of the code with the trace to see what happens.