peteredm
asked on
CCSID Convert 805 to 1208 in ESQL
Having problems converting a message from an MQ queue (recieved via a transmission queue from another OS) in ESQL within a compute node in the broker.
Attempting this conversion as the message flow throws an exception when the CCSID isn't 1208 but is 850.
I can paste the same message in using the put test message feature in mq and it works as it's written natively.
Thought this ESQL would have worked but still get the same problem
CALL CopyEntireMessage();
-- get the message string
DECLARE cMessage CHARACTER CAST(InputRoot.BLOB.BLOB AS CHARACTER ENCODING 546);
-- set but cast accordinly
SET OutputRoot.BLOB.BLOB = CAST (cMessage AS BLOB CCSID 1208);
-- Set MQMD and Properties values
SET OutputRoot.MQMD.CodedCharS etId = 1208;
SET OutputRoot.Properties.Code dCharSetId = 1208;
SET OutputRoot.MQMD.Encoding = 546;
SET OutputRoot.Properties.Enco ding = 546;
Any thoughts?
Attempting this conversion as the message flow throws an exception when the CCSID isn't 1208 but is 850.
I can paste the same message in using the put test message feature in mq and it works as it's written natively.
Thought this ESQL would have worked but still get the same problem
CALL CopyEntireMessage();
-- get the message string
DECLARE cMessage CHARACTER CAST(InputRoot.BLOB.BLOB AS CHARACTER ENCODING 546);
-- set but cast accordinly
SET OutputRoot.BLOB.BLOB = CAST (cMessage AS BLOB CCSID 1208);
-- Set MQMD and Properties values
SET OutputRoot.MQMD.CodedCharS
SET OutputRoot.Properties.Code
SET OutputRoot.MQMD.Encoding = 546;
SET OutputRoot.Properties.Enco
Any thoughts?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER