| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Mulltiple ResultSet Lines from Stored Procedure calls |
« View previous topic :: View next topic » |
| Author |
Message
|
| plewton |
 Posted: Thu Mar 25, 2004 8:56 am Post subject: Mulltiple ResultSet Lines from Stored Procedure calls |
 |
|
Novice
Joined: 20 May 2003
Posts: 14
|
Hi,
Running Msg Broker v5.0.2 on top of DB2 8.1.2. I'm only permitted to interact with my User database via DB2 Stored Procedures (my hands are tied firmly on this one by our standards team  ). I've seen some correspondance and heard that that Msg Broker can't handle Result Sets with more than one row in them returned from a Stored Procedure.
Is this true? If not, what do I need to do when calling the Stored Procedure in order to get multiple line Result Sets returned?
Thanks. |
|
| Back to top |
|
 |
| kirani |
| Posted: Thu Mar 25, 2004 10:57 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
From ESQL reference manual,
| Quote: |
All external procedures have the following restrictions:
Parameters cannot be of the ESQL Reference type.
Parameters cannot map onto the database LOB types (for example, BLOB and CLOB).
Results sets cannot be returned or used as input or output parameters.
|
Also, if you use search on this site, you will find couple of discussions around this topic.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| mgk |
| Posted: Thu Mar 25, 2004 11:46 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
You can work around this with the PASSTHRU function if you can accept a few restrictions:
The PASSTHRU function call can invoke a Stored Procedure that returns a SINGLE resultset (which may or may not have multiple rows - your choice). However it cannot use OUT or INOUT parameters, only IN parameters. It also cannot return scalar values as a retunr value.
There is an example of usage in the ESQL docs - search on PASSTHRU
Cheers,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
