MQSeries.net :: View topic - Concatenation of an integer and a blob

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 » Concatenation of an integer and a blob

Concatenation of an integer and a blob

« View previous topic :: View next topic »

Author

Message

tbt102

Posted: Tue Apr 29, 2003 4:49 am Post subject: Concatenation of an integer and a blob

Apprentice

Joined: 21 Apr 2003
Posts: 28

Hi all,

I would like to concatenate an integer and a blob into OutputRoot."BLOB"."BLOB" .

I'm would like to do something like this
SET OutputRoot."BLOB"."BLOB" = intRepeatCount || InputRoot."BLOB"."BLOB";

The above fails with BIP2430E: Illegal operands '10' and 'X'f5f040f1f.....

I think I need to somehow convert the content of intRepeatCount to a blob or hex value. Not sure how.

Would someone point me in the right direction.

Thanks in advance for any help.

fcotait

Posted: Tue Apr 29, 2003 4:59 am Post subject:

Acolyte

Joined: 28 Feb 2002
Posts: 63
Location: Sao Paulo - Brazil

Use function CAST to convert the values

See ESQL Reference manual

Regards
_________________
Filipe Cotait
IBM Certified System Administrator - WebSphere MQ
IBM Certified Specialist - MQSeries, WebSphere MQ Integrator

pattela

Posted: Tue Apr 29, 2003 5:37 am Post subject:

Newbie

Joined: 15 Apr 2003
Posts: 7
Location: IL

Hi U can cast it
Set OutputRoot."BLOB"."BLOB"=CAST(IntRepeatCount as BLOB) || InputRoot."BLOB"."BLOB";

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Concatenation of an integer and a blob

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