Accessing Oracle from DB2 Stored Procedure

[dougjrs]

Good Afternoon,

I have a Java stored procedure on DB2 z/OS and it is using the Type 4
JDBC driver to access an Oracle database. After I get the data from
the Oracle dataabse I try to return it from my SP as a result set, but
I get an -20213 because the result is from Oracle and not DB2. Can you
convert from an Oracle resultset to a DB2 resultset (and how)?
Thanks,
Doug

[Larry]

Is the Stored Proc on z/OS? If so, you might be able to use Websphere
INformation Integrator as middleware between z/OS and Oracle.

Larry Edelstein

do*****@kc.rr.com wrote:

Good Afternoon,

I have a Java stored procedure on DB2 z/OS and it is using the Type 4
JDBC driver to access an Oracle database. After I get the data from
the Oracle dataabse I try to return it from my SP as a result set, but
I get an -20213 because the result is from Oracle and not DB2. Can you
convert from an Oracle resultset to a DB2 resultset (and how)?
Thanks,
Doug

[dougjrs]

Yes, the SP is on z/OS. I think that II is an extra charge item from
IBM that my company does not license.

I guess that my java program could create a temp table to insert the
data into and then do a select * from that and return the resultset
from that.

Doug

[DA Morgan]

do*****@kc.rr.com wrote:

Good Afternoon,

I have a Java stored procedure on DB2 z/OS and it is using the Type 4
JDBC driver to access an Oracle database. After I get the data from
the Oracle dataabse I try to return it from my SP as a result set, but
I get an -20213 because the result is from Oracle and not DB2. Can you
convert from an Oracle resultset to a DB2 resultset (and how)?
Thanks,
Doug

How are you returning the result set from Oracle? Querying tables/views
directly? Out parameter from a procedure or package? Ref Cursor? Array?
--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace 'x' with 'u' to respond)

[Larry]

Your Java program may need to get pretty sophisicated. You need to
convert all the Oracle datatypes to DB2 data types and also convert
ascii to ebcidic.

Larry Edelstein

do*****@kc.rr.com wrote:

Yes, the SP is on z/OS. I think that II is an extra charge item from
IBM that my company does not license.

I guess that my java program could create a temp table to insert the
data into and then do a select * from that and return the resultset
from that.

Doug