MQSeries.net :: View topic - Clob in esql in Message broker

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 » Clob in esql in Message broker

Clob in esql in Message broker

« View previous topic :: View next topic »

Author

Message

team

Posted: Fri Feb 21, 2014 2:04 am Post subject: Clob in esql in Message broker

Centurion

Joined: 03 Nov 2006
Posts: 108

Hi Team,

When we insert xml/variable into database field which is in clob format using esql and we are using toolkit 7.0.05. DB insert is successful however clob data is not getting inserted.

Could you please provide an example which contains variable being inserted to database table?

happyj

Posted: Fri Feb 21, 2014 2:22 am Post subject:

Voyager

Joined: 07 Feb 2005
Posts: 87

The eqsl INSERT works with CLOB datatypes.
Have you run a debug user trace on your message flow ?
This alongside db tools from whichever dbs you are using should
help you debug this.

mqjeff

Posted: Fri Feb 21, 2014 9:36 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

ESQL insert uses elements in the message tree. These are scalar values of scalar data types.

They are not XML.

Gralgrathor

Posted: Fri Feb 21, 2014 10:00 am Post subject:

Master

Joined: 23 Jul 2009
Posts: 297

Wait, you're saying that you're trying something like this:

Code:

INSERT INTO Database.Table ("XML") VALUES (InputRoot.XMLNSC.*[<]);

?
_________________
A measure of wheat for a penny, and three measures of barley for a penny; and see thou hurt not the oil and the wine.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Clob in esql in Message broker

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