| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| WBIMB Invoking Stored Procedures...Syntax errors |
« View previous topic :: View next topic » |
| Author |
Message
|
| catwood2 |
 Posted: Wed Jul 13, 2005 6:07 am Post subject: WBIMB Invoking Stored Procedures...Syntax errors |
 |
|
Centurion
Joined: 17 May 2002
Posts: 108
|
Thanks in advance for any pointers on the following.
I would like to invoke a stored procedure. Read and re-read the info center section on invoking stored procedures. This is pretty much my first time working in wbimb environment and I'm thinking there must be something basic I'm missing with configuring the esql for the compute node in my flow. I could not get my logic to clear the syntax checker - so, I copied directly from the manual the section on invoking procedures. On the bright side, I am getting the same error that I get with my own logic. I still don't know what's going on tho. I have completely deleted the project and recreated to no avail.
Syntax error:
line 16
Routine "swapParms" is not declared for these arguments.
line 18
Syntax error. Valid options include: FIELD FIRSTCHILD LASTCHILD NEXTSIBLING PREVIOUSSIBLING
| Code: |
CREATE COMPUTE MODULE CATWOOD_PROTO_Compute
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
-- CALL CopyMessageHeaders();
-- CALL CopyEntireMessage();
DECLARE inputParm CHARACTER;
DECLARE outputParm CHARACTER;
DECLARE inputOutputParm CHARACTER;
SET inputParm = 'Hello';
SET inputOutputParm = 'World';
CALL swapParms( inputParm, outputParm, inputOutputParm );
CREATE PROCEDURE swapParms (
IN parm1 CHARACTER,
OUT parm2 CHARACTER,
INOUT parm3 CHARACTER
) EXTERNAL NAME dbSwapParms;
RETURN TRUE;
END;
CREATE PROCEDURE CopyMessageHeaders() BEGIN
DECLARE I INTEGER 1;
DECLARE J INTEGER CARDINALITY(InputRoot.*[]);
WHILE I < J DO
SET OutputRoot.*[I] = InputRoot.*[I];
SET I = I + 1;
END WHILE;
END;
CREATE PROCEDURE CopyEntireMessage() BEGIN
SET OutputRoot = InputRoot;
END;
END MODULE; |
|
|
| Back to top |
|
 |
| JT |
| Posted: Wed Jul 13, 2005 6:23 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Quote: |
CREATE COMPUTE MODULE CATWOOD_PROTO_Compute
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
-- CALL CopyMessageHeaders();
-- CALL CopyEntireMessage();
DECLARE inputParm CHARACTER;
DECLARE outputParm CHARACTER;
DECLARE inputOutputParm CHARACTER;
SET inputParm = 'Hello';
SET inputOutputParm = 'World';
CALL swapParms( inputParm, outputParm, inputOutputParm );
RETURN TRUE;
END;
CREATE PROCEDURE swapParms (
IN parm1 CHARACTER,
OUT parm2 CHARACTER,
INOUT parm3 CHARACTER
) EXTERNAL NAME dbSwapParms;
CREATE PROCEDURE CopyMessageHeaders() BEGIN
DECLARE I INTEGER 1;
DECLARE J INTEGER CARDINALITY(InputRoot.*[]);
WHILE I < J DO
SET OutputRoot.*[I] = InputRoot.*[I];
SET I = I + 1;
END WHILE;
END;
CREATE PROCEDURE CopyEntireMessage() BEGIN
SET OutputRoot = InputRoot;
END;
END MODULE; |
|
|
| Back to top |
|
|
| catwood2 |
| Posted: Wed Jul 13, 2005 6:41 am Post subject: |
|
|
Centurion
Joined: 17 May 2002
Posts: 108
|
|
| 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
|
|
|
|
