MQSeries.net :: View topic - CAST CHAR to HEX CHAR and then on to BLOB???

mapa · Posted: Mon Oct 22, 2001 3:31 am Post subject:

Hi,

I have a compute node in the BLOB domain where I have to add CRLF (hex 0d0a) after some end tags.
I wonder if there is any way to cast from in my example CAST ('</MESSAGE>' AS CHAR HEX) instead of using the hex-string - '3c2f4d4553534147453e'.
No, I don't speak hex fluidly.

-- </MESSAGE>
SET Pos = POSITION( '3c2f4d4553534147453e' IN StrResult);
IF Pos > 0 THEN
SET StrResult = SUBSTRING(StrResult FROM 1 FOR (Pos + 19 )) || '0d0a'
|| SUBSTRING(StrResult FROM (Pos + 20) FOR StrLength);
END IF;

Reading the ESQL Reference manual I can't see a way of doing this.