Accessing remote database via SQL

[Pakna]

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

[Shashi Mannepalli]

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
Pakna wrote:

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

[Gert van der Kooij]

In article <e9**********@sunce.iskon.hr>, pa***@askme.com says...

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

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.??

[Pakna]

Gert van der Kooij wrote:

In article <e9**********@sunce.iskon.hr>, pa***@askme.com says...

>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

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.??

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.