Accessing remote database via SQL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pakna - 12 Jul 2006 13:01 GMT

Hello, I have what may be a beginner's question regarding DB2.

How does one access a remote table on a remote database via SQL? What is
the command string, is there an equivalent of Oracle DBLINK? I hope I
was clear.

If there are more information that I need to supply, please do tell me.

Thank you very much for your replies

Reply to this Message

Shashi Mannepalli - 12 Jul 2006 14:45 GMT

DB2 INFORMATION INTEGRATOR and Do all the setup for FEDERATION
like

1. Create wrapper
2. Create server
3. Create user mappings
4. Create nickname

Then u can do regualr SQL

Shashi Mannepalli

> Hello, I have what may be a beginner's question regarding DB2.
>
[quoted text clipped - 5 lines]
>
> Thank you very much for your replies

Reply to this Message

Gert van der Kooij - 12 Jul 2006 23:05 GMT

> Hello, I have what may be a beginner's question regarding DB2.
>
[quoted text clipped - 5 lines]
>
> Thank you very much for your replies

It depends on what you need. If you want to access a local database and
a remote database from the same program you need to define a federated
database as Shashi allready said. You don't need DB2 Information
Integrator as long as Db2 is the only DBMS invoved.
If you just want to connect to a database on a remote system there are
several options. How are you accessing the db? Java/C/any other
language/webserver/etc.??

Reply to this Message

Pakna - 13 Jul 2006 09:51 GMT

>> Hello, I have what may be a beginner's question regarding DB2.
>>
[quoted text clipped - 13 lines]
> several options. How are you accessing the db? Java/C/any other
> language/webserver/etc.??

There is just another db2 database on a remote server that I wish to
query from my local instance and have the results appear in a local
table and not on remote server.

I really couldn't say how do we connect the db2 on the implementation
level as this is my second day I am actually using it - I connect to
remote database via Quest Central or Control Center, depending on what
do I need.

Reply to this Message