One Star

[resolved] Data not inserted to DB2

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.
One Star

Re: [resolved] Data not inserted to DB2

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

Re: [resolved] Data not inserted to DB2

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