Prev: DB2 Version 8 - Date format automatic translation between USA and ISO
Next: Is it possible to reorg a table via JDBC?
From: dhroller on 21 May 2010 02:07
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.
From: amar on 21 May 2010 10:55
On May 21, 11:07 am, dhroller <DieterRol...(a)web.de> wrote:
> 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/infocenter/db2luw/v9r7/index.jsp?topic=/com..ibm.db2.luw.sql.ref.doc/doc/r0000779.html


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

 | 
Pages: 1
Prev: DB2 Version 8 - Date format automatic translation between USA and ISO
Next: Is it possible to reorg a table via JDBC?