SEO

#1 (**permalink**) 02-27-2008, 07:38 AM

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

#2 (**permalink**) 02-27-2008, 07:38 AM

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

#3 (**permalink**) 02-27-2008, 07:39 AM

In article <e92ob6$skn$1@sunce.iskon.hr>, pakna@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.??

#4 (**permalink**) 02-27-2008, 07:39 AM

Gert van der Kooij wrote:
> In article <e92ob6$skn$1@sunce.iskon.hr>, pakna@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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Accessing remote database via SQL