View previous topic :: View next topic
|
Author |
Message |
rchandran_19
New User
Joined: 08 Mar 2005 Posts: 34
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
rchandran_19
New User
Joined: 08 Mar 2005 Posts: 34
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
You're welcome
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 |
|
|
|