|
View previous topic :: View next topic
|
| Author |
Message |
cdhami
New User
Joined: 24 Jan 2006
Posts: 28
|
|
|
|
Hi all,
Is it possible to connect multiple db2 subsystem using single program
If yess, what is required in appl program to achieve this.
Thanks in advance.
Cdhami |
|
| Back to top |
|
 |
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
cdhami,
Yes. It is possible.
You need to use CONNECT statements in your application program.
| Code: |
EXEC SQL CONNECT TO EASTDB;
-- execute statements referencing objects at EASTDB
EXEC SQL CONNECT TO WESTDB;
-- execute statements referencing objects at WESTDB |
The location names you can get from SYSIBM.LOCATIONS table.
For more complete infomation on CONNECT, take a look at SQL reference manual.
Sushanth |
|
| Back to top |
|
|
|
|
