Link to home
Start Free TrialLog in
Avatar of peteredm
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.CodedCharSetId = 1208;
       SET OutputRoot.Properties.CodedCharSetId = 1208;

       SET OutputRoot.MQMD.Encoding = 546;
       SET OutputRoot.Properties.Encoding = 546;

 
Any thoughts?


ASKER CERTIFIED SOLUTION
Avatar of lgacs
lgacs
Flag of Hungary image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of peteredm
peteredm

ASKER

Thanks