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
No new posts Two Selects in a single select query Rohit Umarjikar DB2 1 Fri Nov 04, 2016 8:46 pm
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm
No new posts Converting multiple VB files to FB fi... Viswanath Reddy JCL & VSAM 6 Mon Aug 08, 2016 11:49 pm
No new posts DB2 CONNECT query mistah kurtz DB2 3 Fri Jul 15, 2016 6:37 pm
No new posts Single step utility for compare and u... ramprakashn JCL & VSAM 5 Fri Apr 29, 2016 3:43 pm


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