| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| Call stored procedure |
« View previous topic :: View next topic » |
| Author |
Message
|
| CAONIMA |
 Posted: Tue Feb 03, 2015 8:32 am Post subject: |
 |
|
Acolyte
Joined: 03 Dec 2014
Posts: 65
|
| Could I use the passthru function? |
|
| Back to top |
|
 |
| Vitor |
| Posted: Tue Feb 03, 2015 8:39 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| CAONIMA wrote: |
| Could I use the passthru function? |
Try it and see.
AFAIK you can't map a LIST or a ROW to a place holder in the VALUES clause of a PASSTHRU function but maybe it will work for you in your particular combination of ESQL level and database.
I'm much more certain the multiple result set (the DYNAMIC RESULT SETS 3 in your procedure definition) isn't supported by that function. So if you get multiple results sets back, you'll either get a runtime error or just the first one. The only time I saw that done was a long time ago on a WMB version far, far away so the behaviour may vary in more modern versions.
This also seems to me a lot of work to build a sledgehammer to crack a fairly small nut.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Feb 03, 2015 8:56 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| You should consider writing a new stored procedure that wraps the one you are trying to call, and perhaps does some of the additional processing you would have to do in IIB after you got back the results from the original call. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Feb 03, 2015 9:26 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqjeff wrote: |
| You should consider writing a new stored procedure that wraps the one you are trying to call, and perhaps does some of the additional processing you would have to do in IIB after you got back the results from the original call. |
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
|
|
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
|
|
|
|
