Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Accessing symbolic parameters

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Vinay N.G

New User


Joined: 15 Sep 2008
Posts: 36
Location: Bangalore

PostPosted: Thu Jan 29, 2009 10:35 am    Post subject: Accessing symbolic parameters
Reply with quote

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
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jan 29, 2009 11:12 am    Post subject:
Reply with quote

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?
Back to top
View user's profile Send private message
Vinay N.G

New User


Joined: 15 Sep 2008
Posts: 36
Location: Bangalore

PostPosted: Thu Jan 29, 2009 11:28 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jan 30, 2009 1:49 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Accessing first bit of PD value rajatbagga DFSORT/ICETOOL 11 Wed May 03, 2017 6:03 am
No new posts LISTCAT on a dataset with symbolic pa... shreya19 JCL & VSAM 5 Fri Apr 07, 2017 5:43 pm
No new posts CICS NEW SIT PARAMETERS CICS BEHAVIOR... Kyle Carroll CICS 0 Fri Nov 04, 2016 11:55 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 6 Thu Oct 27, 2016 10:20 am
No new posts Symbolic Parameters in SYSIN DD state... madishpa DFSORT/ICETOOL 3 Mon Jun 27, 2016 6:23 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us