MQSeries.net :: View topic - how to convert a HEX value to ASCII in ESQL?

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » how to convert a HEX value to ASCII in ESQL?

how to convert a HEX value to ASCII in ESQL?

« View previous topic :: View next topic »

Author

Message

SarithaRao

Posted: Thu May 18, 2006 2:23 pm Post subject: how to convert a HEX value to ASCII in ESQL?

Newbie

Joined: 15 May 2006
Posts: 7

Can anyone help me on how to convert a HEX value to an ASCII in ESQL?

For ex : I have a CHAR variable contains "353435"(hex) and I need to convert this to "545"(ascii) value.

I didn't find any built-in ESQL functions to convert hex to ascii...Are there any? If not, an algorithm to do this would help!

Thank You!

sirsi

Posted: Thu May 18, 2006 2:36 pm Post subject:

Disciple

Joined: 11 Mar 2005
Posts: 177

cast(X'353435' as char CCSID 819)

SarithaRao

Posted: Fri May 19, 2006 2:29 pm Post subject:

Newbie

Joined: 15 May 2006
Posts: 7

Thanks Sirsi! That helped...

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » how to convert a HEX value to ASCII in ESQL?

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP