IBM JDBC help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

amogh - 14 Dec 2005 09:03 GMT

Hi,

I am trying to use the IBM DB2 Universal Database driver (IBM JDBC
package). How do I wrap an Oracle connection within an IBM connection?
Is it possible ?

I tried searching through the documentation and the Internet, but
couldnt find any help on this. Can somebody please help ?

Rgds.
Amogh

Reply to this Message

Knut Stolze - 14 Dec 2005 09:09 GMT

> Hi,
>
[quoted text clipped - 4 lines]
> I tried searching through the documentation and the Internet, but
> couldnt find any help on this. Can somebody please help ?

You might want to have a look at DB2's federated capabilities, which allow
you to access Oracle tables/views like any other table/view in a DB2
database. Maybe this is what you want?

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

amogh - 14 Dec 2005 09:25 GMT

>>Hi,
>>
[quoted text clipped - 8 lines]
> you to access Oracle tables/views like any other table/view in a DB2
> database. Maybe this is what you want?

Hi,

Sounds like exactly what I need! Is there an API specfication on this
technology somewhere. IBM's DW seems to have only white papers on this.
(loads of information! its pretty surprising why documentation is not
kept simple)

It would be great if you could point me to an example where this
technology is used..

Rgds.

Reply to this Message

Mark A - 14 Dec 2005 13:30 GMT

> Sounds like exactly what I need! Is there an API specfication on this
> technology somewhere. IBM's DW seems to have only white papers on this.
[quoted text clipped - 5 lines]
>
> Rgds.

Here are the manuals. I would start with the Federated Systems Guide.
http://www-306.ibm.com/software/data/db2/udb/support/manualsv8.html

Reply to this Message

amogh - 15 Dec 2005 03:27 GMT

>>Sounds like exactly what I need! Is there an API specfication on this
>>technology somewhere. IBM's DW seems to have only white papers on this.
[quoted text clipped - 8 lines]
> Here are the manuals. I would start with the Federated Systems Guide.
> http://www-306.ibm.com/software/data/db2/udb/support/manualsv8.html

Thank you.

Rgds.

Reply to this Message