MQSeries.net :: View topic - error casting a blob to integer

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 » error casting a blob to integer

error casting a blob to integer

« View previous topic :: View next topic »

Author

Message

vijay707

Posted: Thu Oct 28, 2004 4:19 pm Post subject: error casting a blob to integer

Novice

Joined: 12 Feb 2004
Posts: 18

I am having problem casting a blob to integer.

I am using BITXOR funtion to perform
the bitwise XOR on the binary representation of the numbers.

BITXOR(CAST(X '41') as int, 0).

The Exception message is as follows.

The operand of a casting operation was of an unsuitable length for it to be cast to the target data type.
For example, BIT operands must have a length divisible by 8 when casting to BLOB.

Can anyone help me to get around this error.

Thanks in advance.

siliconfish

Posted: Thu Oct 28, 2004 4:57 pm Post subject:

Master

Joined: 12 Aug 2002
Posts: 203
Location: USA

You need not CAST hex to Int .

Quote:

The INTEGER data type holds an integer number in 64-bit twoâ€™s
complement form. This gives a range of values between
-9223372036854775808 and +9223372036854775807. In addition to the
normal integer literal format, integer literals can be written in hexadecimal
notation, for example 0x1234abcd.

_________________
siliconfish

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » error casting a blob to integer

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