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

Basic Send Message to MQ with Java and IBM MQ JMS

Basic Receive Message to MQ with Java and IBM MQ JMS

Configure Database Connection using MyBatis