java - ERRORCODE=-4461, SQLSTATE=42815 in DB2 -


I have exported some data schema A (table x) to XML and I am reading Inserting data into XML and schema b (table y) during inserting data after 20000 records it says that

  com.ibm.db2.jcc.am. SqlSyntaxErrorException: [jcc] [t4] [20111] [11366] [3.63.75] Value is too large for its related use of a host variable host variable = 1 ERRORCODE = -4461, SQLSTATE = 42815 com.ibm.db2. Jcc.am.BatchUpdateException: [JCC] [T4] [102] [10040] [3.63.75] Batch failure   

Batch Subm T was, but was at least one exception to one member of the batch.

"post-text" itemprop = "text">

I had one such problem once I resolved to add XML to the queue size. There was something like:

  & lt; Work & gt; & Lt; Name & gt; Ventas MCC & lt; / Name & gt; & Lt; QueueSize & gt; 100 & lt; / QueueSize & gt; & Lt; QueueNames & gt; TrashQueue & lt; / QueueNames & gt; & Lt; QueryTasks & gt; & Lt; QueryTask & gt; ... & lt; / QueryTask & gt; & Lt; / QueryTasks & gt; & Lt; / Work & gt;   

The query with the queue was launched in batch.

Comments