MQSeries.net :: View topic - Problem with updating list/repeating structure in wbimb/esql

pank2210 · Posted: Tue Apr 18, 2006 1:56 am Post subject:

Hi,

Can some one help to find solution for below mention problem.
I have a list strucutre in a XML (repeating compund structure at some point in input tree) and i have to update a particular list item based on the content of its element.
let say if i have
<myRoot>
<child1>
<a>1</a>
1
<c>1</c>
</child1>
<child1>
<a>2</a>
2
<c>2</c>
</child1>
<child1>
<a>3</a>
3
<c>3</c>
</child1>
<child1>
<a>4</a>
4
<c>4</c>
</child1>
</myRoot>

then can write some thing like this and i want set child1.a to 10 where child1.c=3
------------
declare ref reference to select T.* from OutputRoot.XML.myRoot.child1[] where T.c = 3;
if LASTMOVE then
SET ref.a=10;
end if;
-----------

In short can reference a data dynamically retrieved by select i any logical structure.

other wise to achieve this i need do following code which migth be cubersome perhaps no efficient
--------------------
declare cnt=1;
while cnt <= cardinality(OutputRoot.XML.myRoot.child1[] ) do
if InputRoot.XML.myRoot.child1[cnt] = 3 then
SET InputRoot.XML.myRoot.child1[cnt] = 10;
end if;
end while;
--------------------

Or is there any efficient way to implement solution without using select.

Thanks,
Pankaj.