MQSeries.net :: View topic - What's the size limitation of BLOB field foe ESQL?

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 » What's the size limitation of BLOB field foe ESQL?

What's the size limitation of BLOB field foe ESQL?

« View previous topic :: View next topic »

Author

Message

claire

Posted: Fri Apr 19, 2002 6:21 pm Post subject:

Apprentice

Joined: 10 Apr 2002
Posts: 32

Hi,
Under WMQI 2.1 I use the following ESQL to select BLOB field from database:
Set Environment.VALUES[]=(Select Item T.Msg From Database.Tablename.Msg as T);

I found Environment.VALUES[] will be NULL if there is BLOB field size beyond 10K bytes. What's wrong? Please give me some advice.

Thanks a lot.

claire

Posted: Fri Apr 19, 2002 6:22 pm Post subject:

Apprentice

Joined: 10 Apr 2002
Posts: 32

Hi,
Under WMQI 2.1 I use the following ESQL to select BLOB field from database:
Set Environment.VALUES[]=(Select Item T.Msg From Database.Tablename as T);

I found Environment.VALUES[] will be NULL if there is BLOB field size beyond 10K bytes. What's wrong? Please give me some advice.

Thanks a lot.

amonj

Posted: Sun Apr 21, 2002 9:58 pm Post subject:

Newbie

Joined: 31 Jan 2002
Posts: 2

I also need the answer .
Do any body any suggestion!!
Thanks!!

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » What's the size limitation of BLOB field foe ESQL?

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