Re: ******pl/sql*******

From: Frank Bates <fbates_at_stratos.net>
Date: 2000/04/20
Message-ID: <956267183.978494@newscache.cleveland.core.com>#1/1

To do this, you need the (extra $) Oracle product "Transparent Gateway for DB2" (TG4DB2) [http://technet.oracle.com/doc/gateways/tg4db2/toc.htm] which allows DB2 for OS/390 databases to be accessed as though they were Oracle tables. After installing the TG4DB2 software, you would need to configure it for the specific DB2 subsystem (and tables?). You probably need DB2 Client Application Enabler that is available at http://www.software.ibm.com/data/db2/db2tech/clientpak.html.

On your Oracle8i on NT server, you would then need to create a tnsnames.ora entry for the TG4DB2 server and a database link to the TG4DB2 server   CREATE DATABASE LINK <linkname>
    CONNECT TO <tg4db2_user> IDENTIFIED BY <pwd>     USING 'connect_string';

Finally, you would do:
  INSERT
    INTO <localowner>.<localtable>
    [(<columnlist>)]
    (SELECT <columnlist>

       FROM <tg4db2_owner>.<tg4db2_table>@<linkname>
       WHERE <predicatelist>)

    ;
dhruba <tapashc_at_my-deja.com> wrote in message news:8dlh2o$psb$1_at_nnrp1.deja.com...
> Hi
>
> I have oracle 8.1.5 in NT4 server,
> from sqlplus on this box I can connect to oracle and to another
> db2 database(remote) which is on 0s/390,
> I have 2 common table both on oracle and db2 database.
>
> I need to write a pl/sql which will select data from db2 table and
> insert into oracle table.
>
> I am confused as when I am selecting data from db2 that is actually
> not in this box but in a terminal like,
>
> How can I capture that db2(remote) data and put into oracle(local)table.
>
> please give some advice
>
> rcy
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Apr 20 2000 - 00:00:00 CDT