| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Stoered procedures in MQSI |
« View previous topic :: View next topic » |
| Author |
Message
|
| Andrey |
 Posted: Mon Sep 17, 2001 1:44 am Post subject: |
 |
|
Apprentice
Joined: 02 Sep 2001
Posts: 37
Location: Belarus, Minsk
|
Does anybody know hoi i can correctly call stored procedure which does not return any values? When i've try to insert stored procedure call into Compute node it suppose that PASSTHRU function will return a list and I've tried to use the following code:
SET OutputRoot.XML."Data"."Result"[] = PASSTHRU('{call proc1 (?)}' , InputRoot.XML."Data"."Index");
When that code is performing I catch exception 'ODBC: Invalid cursor state'.
This procedure works fine when i'm using procedure call from DB2 Stored Procedure Builder.
Can anybody help me? |
|
| Back to top |
|
 |
| Outdesign |
| Posted: Mon Sep 17, 2001 2:32 am Post subject: |
|
|
Apprentice
Joined: 16 Sep 2001
Posts: 38
Location: Hampshire, UK
|
The statement to invoke a stored procedure from within a Compute node is (using your example) :
PASSTHRU('{call proc1 (?)}' , InputRoot.XML."Data"."Index");
|
|
| Back to top |
|
|
| Andrey |
| Posted: Mon Sep 17, 2001 3:05 am Post subject: |
|
|
Apprentice
Joined: 02 Sep 2001
Posts: 37
Location: Belarus, Minsk
|
| Quote: |
On 2001-09-17 03:32, Outdesign wrote:
The statement to invoke a stored procedure from within a Compute node is (using your example) :
PASSTHRU('{call proc1 (?)}' , InputRoot.XML."Data"."Index");
|
You are right, but if i insert this string into Compute node as ESQL expression, then SET prefix expected and MQSI displays 'Not valud expression for Compute node' error message.
Only when I type, say
SET OutputRoot.XML."Data"."Result" = PASSTHRU(....);
then error error disappears but runtime exception is thrown. Could you explain it?
[ This Message was edited by: Andrey on 2001-09-17 04:19 ] |
|
| Back to top |
|
|
| Outdesign |
| Posted: Mon Sep 17, 2001 6:49 am Post subject: |
|
|
Apprentice
Joined: 16 Sep 2001
Posts: 38
Location: Hampshire, UK
|
The following Compute statement will deploy to a broker successfully :
PASSTHRU('{call proc1 (?)}' , InputRoot.XML."Data"."Index");
I assume what you are saying is that the GUI ESQL syntax checker
is highlighting this as an error, which is incorrect.
The GUI ESQL syntax checker and the broker ESQL syntax checker are not
the same and as such could be out of sync.
If so, this should be raised with IBM as a GUI ESQL syntax checker error.
|
|
| 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
|
|
|
|
