Posted: Sat Jul 13, 2002 12:33 am Post subject: ASCII value of character data
Novice
Joined: 03 Jul 2002 Posts: 14
Is there some way of getting the ASCII value of a character in ESQL.
eg. if i have a variable x set to characater 't'
x character
x = A
how can i get 65 from this...
is there some function avaiable in ESQL for this
Joined: 05 Sep 2001 Posts: 3779 Location: Torrance, CA, USA
You could get the ASCII value (in HEX form) by casting the char variable to a BLOB variable. You will have to write your own function to convert hex value to interger. _________________ Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
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