MBT/ESQL to Modify XML element names

<Shares>
<Kerry>5</Kerry>
<Fexco>12</Fexco>
<AIB>40</AIB>
</Shares>

Change AIB to BOI instead, Feed XML in to XMLNS format MQ Input Node, Create  MQIN

CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
-- CALL CopyMessageHeaders();
-- CALL CopyEntireMessage();
SET OutputRoot.XMLNS.Data = ROW(InputBody.Shares.Kerry,
InputBody.Shares.Fexco,
(InputBody.Shares.AIB) AS BOI);
RETURN TRUE;
END;

Receive output in MQ Output Node MQOUT

<Data>
<Kerry>5</Kerry>
<Fexco>12</Fexco>
<BOI>40</BOI>
</Data>

Comments

Popular posts from this blog

ActiveMQ, easy to use open source message oriented middleware (MOM)

Basic Send Message to MQ with Java and IBM MQ JMS

MySQL Error Invalid Table or Database Name