MQSeries.net :: View topic - Retrieving values of XML attributes within ESQL

emqueuer · Posted: Thu Jun 21, 2007 7:42 am Post subject:

Hello,

I have an XML input message and and am pulling out various data for later use.

My question is if FIELDNAME is used to retrieve the field name from an XML message how can I reference an Attribute value?

eg how do retrieve the value of "To" from the following?

<Test>
<MapData To="A">
<From>B</From>
<From>C</From>
</MapData>
</Test>

I've declared 'cursor' as a REFERENCE TO InputRoot.XMLNSC.Test so that FIELDNAME(cursor[1]) should provide 'MapData'

The documentation doesn't seem to provide the answer.

Many thanks
Daniel