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>
<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
Post a Comment