MQSeries.net :: View topic - BLOB to CHAR. Simple question?

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 » BLOB to CHAR. Simple question?

BLOB to CHAR. Simple question?

« View previous topic :: View next topic »

Author

Message

oli

Posted: Wed May 14, 2008 10:58 pm Post subject: BLOB to CHAR. Simple question?

Acolyte

Joined: 14 Jul 2006
Posts: 68
Location: Germany

Hi all,

I have a very simple problem but I'm not able to solve. With RFHUtil I put a message with text "This is a test" into a queue. The MQInputNode is configured with message domain BLOB. Within a ComputeNode I want to have the text in a CHAR variable. I tried the following:

Code:

DECLARE theText CHAR;
SET theText = CAST(InputRoot."BLOB"."BLOB" as CHAR CCSID InputRoot.MQMD.CodedCharSetId);

But I only get the following string:
X'5468697320697320612074657374'

What am I doing wrong?

Thanks for your help,

Oli
[/code]

Gaya3

Posted: Wed May 14, 2008 11:18 pm Post subject:

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US

its perfectly working...

SET theText = CAST(InputRoot."BLOB"."BLOB" as CHARACTER CCSID InputRoot.MQMD.CodedCharSetId);

Just try out once again

Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » BLOB to CHAR. Simple question?

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