Re: Oracle Web Server / MVS DB2 Data Access

From: Michael Hunsucker <ihp_at_atl.mindspring.com>
Date: 1997/04/08
Message-ID: <5idlfg$vph@camel1.mindspring.com>#1/1

If you are using the Oracle Transparent Gateway for IBM DRDA the answer is no. The DB2 tables can be accessed directly via a distributed Oracle link that references a gateway 'instance'. The reference needs to be defined with the appropriate DB2 qualifier (or schema name in Oracle terms)
ex. select * from db2_qualifier.db2_table_name_at_oracle_link;

You would likely want to use synonyms or views to simplify the syntax.

If you need some more info email me directly.

smakar_at_primenet.com (Stevan R. Makarevich) wrote:

>Background - I will be developing a WEB architecture consisting of an
>Oracle Web Server 2.01 application accessing IBM MVS DB2 4.1 tables
>via an Oracle Transparent Gateway using SQLNet.

>Question - Do DB2 table definitions have to be defined in the Oracle
>Instant in order to query DB2 tables using PL/SQL?

>Any help or experience with this would be greatly appreciated.
Received on Tue Apr 08 1997 - 00:00:00 CDT