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
 

 

how can i connect to different subsystem with in a single pr

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
iitpraveen

New User


Joined: 12 Dec 2005
Posts: 2

PostPosted: Mon Dec 12, 2005 1:00 pm    Post subject: how can i connect to different subsystem with in a single pr
Reply with quote

Hi,
Please help me in finding a way to set up my JCL and Program so that my program can query on the table which are in different sub sytems EX; DB2T and DB2Q.

Also If I have a calling problem which was BOUND different plan other than my calling program, how do I mention this plan name. TO be more clear I have two program A calling B program. A is bound to PLAN_A and B is bound PLAN_B. In this case what should be my JCL to point to.
Please explanin
Back to top
View user's profile Send private message

vidhata27

New User


Joined: 13 Oct 2005
Posts: 4
Location: Mumbai

PostPosted: Mon Dec 12, 2005 5:59 pm    Post subject: Re: how can i connect to different subsystem with in a singl
Reply with quote

Hi,

Using escalate variables in JCL you can point to different sub system..

Regards,
Sandeep
Back to top
View user's profile Send private message
iitpraveen

New User


Joined: 12 Dec 2005
Posts: 2

PostPosted: Mon Dec 12, 2005 6:14 pm    Post subject: Re: how can i connect to different subsystem with in a singl
Reply with quote

Thanks for spending your time and reply. I am not aware of this variable. Can you please elaborate more or point me to some sites on this. Or send me some attachments with examples. Thanks in advance
Back to top
View user's profile Send private message
Jag

New User


Joined: 07 Dec 2005
Posts: 30
Location: India

PostPosted: Tue Dec 13, 2005 9:10 pm    Post subject: Re: how can i connect to different subsystem with in a singl
Reply with quote

Hi friends,

I do have a little bit doubt..Could you please what escalate varaibles are and how to use them..

I think we cannt use different subsystems each one in called and calling programs as it will be defined in one step of JCL and the PARM which we will pass will contain the substem if DB2(ONE) and the first program which will call the subprgram and we will not specify the subprograms DB2 subsystem anywhere....


But one thing is we can use two subsystems for two differnent prgrams which will run by two steps in JCL...


Correct me if i am wrong
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. SDSF multiple spool datasets extracte... PJAlarcon CLIST & REXX 1 Fri Apr 21, 2017 10:50 pm
No new posts Connect:Direct - RC=000000FF MSG=SVTM... R.Manivannan All Other Mainframe Topics 3 Fri Apr 21, 2017 1:30 am
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts Splitting of single report to seperat... abdulrafi TSO/ISPF 7 Mon Mar 27, 2017 3:59 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm


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