MQSeries.net :: View topic

geethgubi · Posted: Sat Jan 10, 2009 1:02 pm Post subject:

I have an xml like the below. I have 2 message flows. I need some of the values of n:NameValuePair like I just need only the status and the last name in the 1st message flow and FirstName, lastname and status in my second messageflow. I am extracting these values by looping (using while loop) through all the n:NameValuePair in n:NameValuePairs and checking the value of <n:Name>Status</n:Name>
and if it is my required element I get the value of <n:Value></n:Value> element. Since its performance intensive to loop through all these n:NameValuePair just to get one or 2 values, I used like this n:NameValuePairs.n:NameValuePair[2].n:Value wherever I need whatever. But as thats not the good way of coding. I would like to know is there any generic way of extracting the value of any of the any element in esql code? As I am the newbie with Message broker. Can someone pls help me out with this query? Thanks.

<n:NameValuePairs>
<n:NameValuePair>
<n:Name>Status</n:Name>
<n:Value></n:Value>
</n:NameValuePair>
<n:NameValuePair>
<n:Name>FirstName</n:Name>
<n:Value></n:Value>
</n:NameValuePair>
<n:NameValuePair>
<n:Name>MiddleName</n:Name>
<n:Value></n:Value>
</n:NameValuePair>
<n:NameValuePair>
<n:Name>LastName</n:Name>
<n:Value></n:Value>
</n:NameValuePair>
</n:NameValuePairs>