MQSeries.net :: View topic

srailkar · Posted: Wed Jun 01, 2005 8:10 am Post subject:

Here's my esql in the compute node :

DECLARE EFROM CHAR;
SET EFROM = 'sha.railkar@to.com';
DECLARE ESUB CHAR;
SET ESUB = 'An e-mail from OF for validation sent by WBIMB';
SET OutputRoot.XML.Message.From = EFROM;
SET OutputRoot.XML.Message.To = TRIM(InputRoot.XML.MessageHDR.UserValidatoremail);
SET OutputRoot.XML.Message.Subject = ESUB;
DECLARE L INTEGER 1;
DECLARE M INTEGER CARDINALITY(InputRoot.XML.MessageHDR.*[]);
WHILE L < M DO
SET OutputRoot.XML.Message.Body.Line[L] = InputRoot.XML.MessageHDR.*[L];
SET L = L + 1;
END WHILE;
SET OutputRoot.XML.Message.EncodingBase64.(XML.Attribute)ContentType = 'text/plain';
SET OutputRoot.XML.Message.EncodingBase64.(XML.CDataSection) = Cast(InputRoot.BLOB.BLOB as CHAR);
END;

I am getting Part of my XML into the body of the email, however, I would like to get all the XML with its elements into the body.

email body output:
http://tempuri.org/InBnd WrkStationHeaderXML.xsd

railkarsh

railkarsh2005052210020045.req

OF

OFREQ

TMM

04709389S

ACTIVE

OFREQ

OFREQ

5

247

C:\railkash\oc\in

vvvvvvvvv

bodej

sha.railkar@to.com

bodej

Guidance appreciated.