MQSeries.net :: View topic

binitkgupta2802 · Posted: Thu Apr 02, 2015 2:01 am Post subject: BLOB format message handling

Hi,
I am stuck up in a BLOB conversion. Below is the code snippet

DECLARE A CHARACTER;
SET A = '166'; -- In real scenerio the value would come in message

DECLARE B BLOB;
SET B = X'0000000000000A' ; -- need to substitute value of A

SET B = X'0000000000000166' -- this works for proceeding code

Request you to help me to set the value of B which should take the value of A dynamically.