MQSeries.net :: View topic

issac · Posted: Sat May 21, 2011 7:09 pm Post subject:

Hello,

I've managed to save contents of the XML request into DB by ESQL like this:

CREATE COMPUTE MODULE dispatchRequest_Compute_to_Save_Request_History
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
SET OutputRoot = InputRoot;
--保存命令历史
DECLARE vasNs NAMESPACE 'http://futurehost.com/vas';
DECLARE taskChar CHARACTER InputRoot.XMLNSC.vasNs:RequestM.vasNs:task;
--保存请求报文
DECLARE propRef REFERENCE TO InputRoot.Properties;
DECLARE inCCSID INT propRef.CodedCharSetId;
DECLARE inEncoding INT propRef.Encoding;
DECLARE dataBlob BLOB ASBITSTREAM(InputRoot.XMLNSC, inEncoding, inCCSID);
DECLARE dataChar CHAR CAST(dataBlob AS CHAR CCSID inCCSID);
--使用MSG ID作为REQUEST_ID
DECLARE msgidChar CHARACTER Cast(InputRoot.MQMD.MsgId as CHARACTER);
--------------------------
INSERT INTO Database.ISSAC.REQUEST_HISTORY(TASK, DATA, TIME, REQUEST_ID)
VALUES(taskChar, dataChar, CURRENT_TIMESTAMP, msgidChar);
RETURN TRUE;
END;
END MODULE;

I'm trying to do the same thing by mapping. I think it should be similar. But I have no idea how to convert the message to BLOB and then CAST to a string in xpath. I'm still googling for an answer. Would anyone please help?
_________________
Bazinga!