| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Calling SP using PASSTHRU |
« View previous topic :: View next topic » |
| Author |
Message
|
| vandi |
 Posted: Wed Mar 11, 2009 2:44 pm Post subject: Calling SP using PASSTHRU |
 |
|
Acolyte
Joined: 13 Dec 2008
Posts: 67
|
Hi All,
I was going thru the IBM Documentation(Infocenter) and also posts on SP for using Stored Procedures.
In IBM Infocenter, I see
| Quote: |
| Do not use PASSTHRU to call stored procedures; instead, use the CALL statement because PASSTHRU imposes limitations (you cannot use output parameters, for example). |
But, in some posts on SP it is suggested to use PASSTHRU to call SP.
I am confused about it.
Can you pls let m eknow if we can use PASSTHRU to call SP?
Thanks
Vandi |
|
| Back to top |
|
 |
| mgk |
| Posted: Wed Mar 11, 2009 2:51 pm Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
You can use PASSTHRU to call a stored procedure if you really want to, but I would like to know why you think you need to? Almost all the things you would want to call a procedure are available through the CALL / CREATE PROCEDURE route, except perhaps named parameters and default values. There would also be little difference in performance, infact it may actually be slower to use PASSTHRU to call an SP due to the internal caching that CALL does for procedures.
So please let me know why you think you need to do this, I'm intrigued 
_________________
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 |
|
|
| vandi |
| Posted: Wed Mar 11, 2009 2:58 pm Post subject: |
|
|
Acolyte
Joined: 13 Dec 2008
Posts: 67
|
Hi,
Thanks for the info.
I have not used stored procedures before. To get complete understanding of it, I was going thru the posts as well as IBM documentation.
As it was mentioned in the documentation about not using PASSTHRU to call SP, I would like to know why it is so.
Thanks
Vandi |
|
| Back to top |
|
|
| MQEnthu |
| Posted: Wed Mar 11, 2009 8:40 pm Post subject: |
|
|
Partisan
Joined: 06 Oct 2008
Posts: 329
Location: India
|
| vandi wrote: |
| .....I would like to know why it is so. |
| vandi wrote: |
| Quote: |
| Do not use PASSTHRU to call stored procedures; instead, use the CALL statement because PASSTHRU imposes limitations (you cannot use output parameters, for example). |
|
_________________
-----------------------------------------------
It is good to remember the past,
but don't let past capture your future |
|
| 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
|
|
|
|
