OraFAQ Forum: Other Operating Systems » Handling a result set from a db2 z/os Stored procedure

Home » Infrastructure » Other Operating Systems » Handling a result set from a db2 z/os Stored procedure (db2 z/os - oralce 10 -otg)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Handling a result set from a db2 z/os Stored procedure [message #298564]

Wed, 06 February 2008 07:41

rporco
Messages: 2
Registered: February 2008
Location: Rosie

Junior Member

Does Oracle handle result set returned from a db2 Z/os store procedure .
We are not able to achieve this . Is it a limitation or are we missing something . Does any one have an example code .

thanks
Rosie
Db2 Dba

Report message to a moderator

Re: Handling a result set from a db2 z/os Stored procedure [message #298610 is a reply to message #298564]

Wed, 06 February 2008 15:02

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm not sure I understood the situation ...

You have a DB2 database and there's a stored procedure which, as a result, produces some record set.

Now you'd like Oracle to handle this record set, returned by a DB2 stored procedure? Is that correct?

If so, what exactly would you like Oracle to with it? Is it a file and you'd like to "import" its contents into an Oracle table? Is it something different?

Could you, please, explain it a little bit more?

Report message to a moderator

Re: Handling a result set from a db2 z/os Stored procedure [message #298754 is a reply to message #298610]

Thu, 07 February 2008 08:45

rporco
Messages: 2
Registered: February 2008
Location: Rosie

Junior Member

That is correct
We have Db2 V7 on z/os
with the oracle transparent GAteway
and Oracle on solaris

* Oracle HS Agent
* OSDI SUBSYSTEM ORAS SERVICE OTGXSRV
* connected to DB2 SUBSYSTEM DB2X
* TG4DB2 Version.............: 10.2.0.2.0
* DB2 Version................: 7.1.0

From Oracle issue a CALL StudentGet@DB2X (session)

on DB2 : the Sp "SIS.StudentGet" returns a record set , 1000 rows based on the input parm Session

We want the Application on the Oracle side to Fetch through each of the returned rows and process them individually

I hope this is clearer
thanks

Report message to a moderator

Re: Handling a result set from a db2 z/os Stored procedure [message #303215 is a reply to message #298754]

Thu, 28 February 2008 07:34

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Done a similar thing between Informix and Oracle
Have a look at DBMS_HS_PASSTHROUGH package

Report message to a moderator

Previous Topic:	Oracle terminates support for OS/390
Next Topic:	How to run a set of SQL statements in AS400

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 10:35:55 CST 2025