CLOB insert with Batch Update

#1

I'm inserting a CLOB using batch update. If the size of the CLOB
exceeds 32k, I'm getting a -102. Is there a way of inserting larger
CLOBs in a SQL Batch statement. I'm running DB2 V 9.7.

#2

On May 21, 11:07*am, dhroller <DieterRol... (AT) web (DOT) de> wrote:

Quote:

I'm inserting a CLOB using batch update. If the size of the CLOB
exceeds 32k, I'm getting a -102. Is there a way of inserting larger
CLOBs in a SQL Batch statement. I'm running DB2 V 9.7.

docs tells CLOB will support upto 2GB length

http://publib.boulder.ibm.com/infoce.../r0000779.html

did you check same will fail on normal update(with batch update)..?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

CLOB insert with Batch Update

comp.databases.ibm-db2 comp.databases.ibm-db2

CLOB insert with Batch Update - 05-21-2010 , 01:07 AM

Re: CLOB insert with Batch Update - 05-21-2010 , 09:55 AM