| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Calling a specifc sybase stored procedure |
« View previous topic :: View next topic » |
| Author |
Message
|
| prabuk |
 Posted: Fri Mar 14, 2003 12:00 pm Post subject: Calling a specifc sybase stored procedure |
 |
|
Novice
Joined: 14 Mar 2003
Posts: 19
Location: JerseyCity, NJ
|
We are having a requirement to call a stored proc which has output params defined specific to sybase, if we have to execute and get the output we should execute as follows from ISQL command line,
declare @TBuf2 varchar(255)
declare @TBufAcct2 varchar(255)
declare @TBuf1 varchar(255)
declare @TBufAcct1 varchar(255)
declare @IbeneBankBuf varchar(255)
declare @IbeneBuf varchar(255)
declare @IacctBuf varchar(255)
declare @IsubAcctBuf varchar(255)
declare @InetPayNoteBuf varchar(255)
declare @INoteBuf varchar(255)
declare @statusString varchar(255)
exec PaymentInstruction_format
null,
null,
null,
"PMASTER",
"DLR",
"NYC",
"123456",
"A",
"USD",
"20030228",
"CHSE",
"NYC",
@TBuf2 output,
@TBufAcct2 output,
@TBuf1 output,
@TBufAcct1 output,
@IbeneBankBuf output,
@IbeneBuf output,
@IacctBuf output,
@IsubAcctBuf output,
@InetPayNoteBuf output,
@INoteBuf output,
@statusString output
If you check the SQL above, before calling the stored procedure we have to declare all the output params. I guess, in PASSTHRU, we could execute statement by statement only. All above statements are supposed to be executed as a batch. How could we accomdate this in ESQL?
Thanks
Prabu |
|
| Back to top |
|
 |
| kirani |
| Posted: Fri Mar 14, 2003 10:06 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Take a look at CREATE PROCEDURE statement in WMQI 2.1 CSD2 and above, it might help you.
_________________
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 |
|
|
| prabuk |
| Posted: Mon Mar 17, 2003 9:23 am Post subject: |
|
|
Novice
Joined: 14 Mar 2003
Posts: 19
Location: JerseyCity, NJ
|
Thanks Kiran.
Do you know where I can get the detailed documentation of CREATE PROCEDURE for WMQI 2.1 CSD2 and above?
Thanks again,
Prabu |
|
| Back to top |
|
|
| kirani |
| Posted: Mon Mar 17, 2003 12:24 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
WMQI ESQL Reference manual.
_________________
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 |
|
|
|
|
|
| |
|
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
|
|
|
|
