MQSeries.net :: View topic - Transform String in HEX format to ASCII representation

jbustamante · Posted: Tue May 03, 2005 10:38 pm Post subject:

Hi! first of all, sorry for my english, I'm a chilean people.
I have an xml message where it comes a value that is in HEX format. I have to transform this HEX "string" into the ASCII representation.
With an example:
The input message is
<TRX>
<someValue>A001</someValue>
<otherValue>0125</otherValue>
</TRX>

I need to transform this values to
<TRX>
<result>..</result> [A0 and 01 has no representation in ASCII]
<result>.%</result> [01 same as above end 25 is % in ASCII]
</TRX>

with the following ESQL (as example) code:

DECLARE blbCDATA BLOB;
DECLARE chrDATA CHAR InputRoot.XML.TRX.someValue;

SET blbCDATA = CAST(chrDATA AS BLOB);
SET chrDATA = CAST(blbCDATA AS CHARACTER CCSID InputRoot.Properties.CodedCharSetId);
SET OutputRoot.XML.TRX.result=chrDATA;

I get:

<TRX>
<result>41303031</result>
<result>30313235</result>
</TRX>

Can you help me with this, better if it is with an ESQL Example.