topic Re: [resolved] Data not inserted to DB2 in Talend Studio

[resolved] Data not inserted to DB2

Anonymous — Mon, 02 Mar 2015 04:03:36 GMT

Hi,
Anyone can help me.
I'm trying load data to DB2. The column and table was created in DB2 but the data not insert to DB2.
There is the error : Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4228, SQLSTATE=null
Before load, i used tLogRow to show the data. But there is no problem.
Thank you.

Re: [resolved] Data not inserted to DB2

Anonymous — Mon, 02 Mar 2015 04:28:28 GMT

if using commit and rollback component,
then you have to use tDBconnection. not just tDBSQLinput

Re: [resolved] Data not inserted to DB2

Anonymous — Mon, 02 Mar 2015 06:46:09 GMT

Shihang, TQ for ur help..
After checking, there is diffrent data type on other table.