Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 CICS EZASOKET CONNECT using DNS name ankit.jain CICS 1 Tue Jan 16, 2018 7:24 pm
No new posts Formatting multiple records to a sing... Vignesh Sid SYNCSORT 3 Tue Nov 07, 2017 12:22 pm
No new posts More than 1 Include criteria for sing... Roy Ware SYNCSORT 6 Wed Sep 13, 2017 11:45 pm
No new posts Multiple VSAM files single output fil... Mohan Kothakota DFSORT/ICETOOL 11 Wed Aug 09, 2017 7:57 pm
No new posts Read two inputs and write into output... murali.andaluri DFSORT/ICETOOL 6 Wed Jul 26, 2017 7:35 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us