DB2 中的 ERRORCODE=-4461,SQLSTATE=42815

ERRORCODE=-4461, SQLSTATE=42815 in DB2(DB2 中的 ERRORCODE=-4461,SQLSTATE=42815)

本文介绍了DB2 中的 ERRORCODE=-4461,SQLSTATE=42815的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我已经将一些数据从模式 A(表 x)导出到 XML,我正在读取 XML 并将数据插入到模式 B(表 y)中.在 20000 条记录之后插入数据时,它说

I have exported some data from schema A (table x)to XML and I am reading the XML and inserting the data into schema B(table y). while inserting the data after 20000 records it says

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

该批次已提交,但该批次的单个成员至少发生了一次异常.

The batch was submitted, but at least one exception occurred on an individual member of the batch.

我比较了表 x 和表 y 中对应列的数据类型,它们是相同的.源和目标中的标识(自动增量)col 和 LONG VARCHAR 都是 BIGINT..

I compared the data types of the corresponding columns in table x and table y they are the same. It is BIGINT for the identity(Auto increment) col and LONG VARCHAR in both source and destination..

请帮助解决此问题.

推荐答案

我曾经遇到过类似的问题.我解决了将队列大小添加到 XML 中的问题.在我的情况下是这样的:

I had a similar problem one time. I solved it adding to the XML the queue size. In my case was something like this:

<task>
   <name>Ventas MCC</name>
   <queueSize>100</queueSize>
   <queueNames>trashQueue</queueNames>
   <queryTasks>
     <queryTask>...</queryTask>
   </queryTasks>
</task>

使用 queueSize 批量启动查询.

With the queueSize the queries was launched in batch.

这篇关于DB2 中的 ERRORCODE=-4461,SQLSTATE=42815的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本文标题为:DB2 中的 ERRORCODE=-4461,SQLSTATE=42815

基础教程推荐