IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Can we access tables in two different regions with a join???


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rchandran_19

New User


Joined: 08 Mar 2005
Posts: 34

PostPosted: Thu Dec 06, 2007 4:07 am
Reply with quote

Hi All,

I have data in DB2 tables, which are existing in 2 different production regions. I have to code a select statement in my COBOL program which is region 1, to get values from table1(region1) and table 2(region2).....is it possible?? If so, can you show an example.

Thanks,
RC
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Thu Dec 06, 2007 4:14 am
Reply with quote

Hello,

I'd suggest you talk with your dba(s) to see if this is permitted in your environment and how you should proceed if it is permissable.
Back to top
View user's profile Send private message
rchandran_19

New User


Joined: 08 Mar 2005
Posts: 34

PostPosted: Thu Dec 06, 2007 4:20 am
Reply with quote

dick scherrer wrote:
Hello,

I'd suggest you talk with your dba(s) to see if this is permitted in your environment and how you should proceed if it is permissable.


Thanks Dick,

I'll ask my DBA for further assistance....i was not sure earlier whether I should ask him or not....now I'll ask him.

-RC
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Thu Dec 06, 2007 4:37 am
Reply with quote

You're welcome icon_smile.gif

As there are often rules specific to an organization, it is usually a good idea to verify that your approach is within these rules.

If there are then questions about the direction the organization requires, we will hopefully be able to offer suggestions.

Good luck!
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts How to access web services/website? Mainframe Interview Questions 4
No new posts Join multiple records using splice DFSORT/ICETOOL 5
No new posts Join 2 files according to one key field. JCL & VSAM 3
No new posts access the last host command CLIST & REXX 2
Search our Forums:

Back to Top