View Single Post

   
  #2 (permalink)  
Old 02-27-2008, 07:38 AM
Shashi Mannepalli
 
Posts: n/a
Default Re: Accessing remote database via SQL

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


Reply With Quote