By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,590 Members | 2,174 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,590 IT Pros & Developers. It's quick & easy.

Accessing Oracle from DB2 Stored Procedure

P: n/a

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

Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a
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)
Nov 12 '05 #4

P: n/a
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

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.