MQSeries.net :: View topic

pjaffe · Posted: Tue May 17, 2005 1:57 pm Post subject:

I have the following WMQI v5 code that is giving me a syntax error in the toolkit. I have to believe it is because I am doing something that is not valid as opposed to just missing a character somewhere. Maybe not. The cursor error is shown on line 5 after "trgt". I am not able to create the BAR file until I clear this error.

CREATE PROCEDURE SetIndex(IN trgt REFERENCE) BEGIN
DECLARE i,indexnum INT;
SET i = 1;
WHILE i <= 3 DO
SET trgt[i].SECTION_X = i;
SET i = i + 1;
END WHILE;
END;

The xml tree that it might populate could look like this before executing the procedure:

<root>
<dept>
<Name>A</Name>
</dept>
<dept>
<Name>B</Name>
</dept>
<dept>
<Name>C</Name>
</dept>
</root>

The procedure would be called as:

CALL SetIndex(OutputRoot.XML.Root.dept);

The expected result would be:

<root>
<dept>
<SECTION_X>1</SECTION_X>
<Name>A</Name>
</dept>
<dept>
<SECTION_X>2</SECTION_X>
<Name>B</Name>
</dept>
<dept>
<SECTION_X>3</SECTION_X>
<Name>C</Name>
</dept>
</root>

I am looking for suggestions about either how to correct what I have started or suggestions about a better way to build it. Please understand that the actual message tree is more complex and much larger.