MQSeries.net :: View topic - Query on TDS Message format -- MB5.0.

sarathsps · Posted: Tue Jun 27, 2006 12:28 am Post subject:

Hi ,

I am using MB5.0.

I am having a XML as a input message and parsing it using a MRM parser using a XML message set.

The XML structure is like this

<Product>
<Item>
<dept>1 </dept>
<class>20 </class>
<subclass>300</subclass>
</Item>
<Item>
<dept>2 </dept>
<class>21 </class>
<subclass>301</subclass>
</Item>
<Item>
<dept>3</dept>
<class>22 </class>
<subclass>302</subclass>
</Item>
</Product>

In my ESQL i am concatnating all the dept values , all the class values and all the subclass values with a delimiter ,

The output i need to achieve is

DEPT = 1,2,3
CLASS =20,21,22 and subclass = 300,301,302

I can still use string manipulation functions in ESQL to do it. In the realtime we are expecting thousands of Items and doing a string manipulation will be a overhead.
So i am thinking to achive the same by having a seperate TDS message with the delimiter ,.
In the ESQL i need to use the message set for concatenating the values.

Please let me know if it is feasible, if feasible please give some direction for me to proceed.

Thanks in advance, Partha