Home » Infrastructure » Other Operating Systems » Handling a result set from a db2 z/os Stored procedure (db2 z/os - oralce 10 -otg)
Handling a result set from a db2 z/os Stored procedure [message #298564] Wed, 06 February 2008 07:41 Go to next message
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
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 Go to previous messageGo to next message
Littlefoot
Messages: 18844
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?
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 Go to previous messageGo to next message
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
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 Go to previous message
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
Previous Topic: Oracle terminates support for OS/390
Next Topic: How to run a set of SQL statements in AS400
Goto Forum:
  


Current Time: Wed Apr 23 19:50:22 CDT 2014

Total time taken to generate the page: 0.10587 seconds