I have exported some data schema A (table x) to Batch Subm T was, but was at least one exception to one member of the batch. I had one such problem once I resolved to add XML to the queue size. There was something like: The query with the queue was launched in batch. 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
& 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;
Comments
Post a Comment