Re: Help with Oracle -- DB2 gateway!

"Mark E. Porterfield" <portrfld_at_nauticom.net> wrote:
>Check to see if those tables are DB2 tables. What Oracle has to do in some
>cases is pull ALL DB2 table data to the Oracle database in order to perform the
>query. This generally happens when you are performing SQL that is not DB2
>standard. Check the manuals Oracle sent for option that should not be used
>against the DB2 tables. The DB2 Gateway is really a dumb animal and there is
>very very little you can do to configure it.

The "transparent" part of the Oracle Transparent Gateways refers to the fact that you can integrate DB2 (and other "foreign" data) access into your Oracle applications using Oracle SQL. Under a strict interpretation this means surprisingly few builtin functions, for example, can be passed through to be processed by DB2 if the results are to match what Oracle would produce. Even the venerable COUNT function (as in "SELECT COUNT(...)") works somewhat differently in DB2.

I haven't looked recently, but I think some of the gateways (the DB2 and DRDA gateways in particular) may have loosened their enforcement of "transparent" somewhat to allow some common SQL functions to pass through even though they don't have precisely the same meaning in DB2. Check the gateway doc, since these could be something that you have to specify in the gateway configuration file or elsewhere.

/b

--
Bill Manry - IBM Products Division - Oracle Corp. USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.
Remove the "." from "B.Manry" to email me.