MQSeries.net :: View topic

wyatt · Posted: Tue Sep 19, 2006 8:49 am Post subject:

Good People

Using ESQL, how can I cast a BLOB data type to CHAR data type?

For example

DECLARE bData BLOB;
SET bData = Substring(InputRoot.BLOB.BLOB from 4 for 4);

SET Environment.chData = CAST (bData as CHAR);

The message flow debugger displays expected message types; e.g. SET Environment.chData is CHARACTER but the contents are represented as with value X'42434143'.

Subquent String functions on Environment.chData do not provide expected results; e.g
DECLARE myVar CHAR;
SET myVar= SUBSTRING(Environment.chData from 1 for 1);
...myVar contians 'X'

Thanks