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

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

dougjrs@kc.rr.com wrote:[color=blue]
> 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
>[/color]

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

dougjrs@kc.rr.com wrote:[color=blue]
> 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[/color]

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
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

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

dougjrs@kc.rr.com wrote:[color=blue]
> 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
>[/color]