By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,572 Members | 946 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,572 IT Pros & Developers. It's quick & easy.

Accessing remote database via SQL

P: n/a
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
Jul 12 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Jul 12 '06 #2

P: n/a
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.??
Jul 12 '06 #3

P: n/a
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.
Jul 13 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.