MQSeries.net :: View topic

Maverik · Posted: Thu Jun 23, 2005 4:00 am Post subject:

Hi

Help me out with this...

Assume i have three fields A,B and C. This lies under a root
<Message>
<ABC>
<A> <A>
<B> <B>
<C> <C>
</ABC>
<ABC
<A> <A>
<B> <B>
<C> <C>
</ABC>
and so on......ending with Message..

I can have multiple occurances of <ABC>

I have to do a SELECT twice from a reference ( say REF_1) I have made to this XML.

My first SELECT is working fine.....when i use it the second time it is referencing only the last occurance of <ABC>....i.e REF_1 is pointing to the last occurance of <ABC>

1. First problem is : How can i set the reference back to the first.....???

NOTE: I do not want to use a WHILE LASTMOVE....I am able to make it work with a WHILE, as i set a new reference variable (say REF_2) with the first row in the array....... as DECLARE REF_2 REFERENCE TO REF_1[1];

How do i set REF_1 REFERENCE TO REF_1[1]; This is not working........

2. Another problem is : How can I make my SELECT stop the moment i find the first occurance.....i.e is there any SELECT DISTINCT in ESQL ????