DB2 Insert Error : SQLCODE: -206, SQLSTATE: 42703, SQLERRMC: Column0

[ganeshK]

Hi, Currently i am testing simple test file for DB2 Insert, The Job throwing below error. Please help to resolve.

Starting job DB2InsertJob at 12:19 22/06/2020.
[statistics] connecting to socket on port XXXX
[statistics] connected
Exception in component tDBOutput_2 (DB2InsertJob)
com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703, SQLERRMC: Column0
at com.ibm.db2.jcc.c.kh.c(kh.java:1660)
at com.ibm.db2.jcc.c.kh.d(kh.java:1648)
at com.ibm.db2.jcc.c.kh.a(kh.java:1205)
at com.ibm.db2.jcc.b.db.g(db.java:139)
at com.ibm.db2.jcc.b.db.a(db.java:39)
at com.ibm.db2.jcc.b.t.a(t.java:34)
at com.ibm.db2.jcc.b.sb.f(sb.java:142)
at com.ibm.db2.jcc.c.kh.m(kh.java:1176)
at com.ibm.db2.jcc.c.lh.bb(lh.java:1941)
at com.ibm.db2.jcc.c.lh.gb(lh.java:2041)
at com.ibm.db2.jcc.c.lh.addBatch(lh.java:1449)
at ascii.db2insertjob_0_1.DB2InsertJob.tFileInputDelimited_2Process(DB2InsertJob.java:843)
at ascii.db2insertjob_0_1.DB2InsertJob.tDBConnection_2Process(DB2InsertJob.java:419)
at ascii.db2insertjob_0_1.DB2InsertJob.runJobInTOS(DB2InsertJob.java:1368)
at ascii.db2insertjob_0_1.DB2InsertJob.main(DB2InsertJob.java:1217)
[statistics] disconnected

Job DB2InsertJob ended at 12:19 22/06/2020. [Exit code = 1]

[vapukov]

Hi,

in 99.99% of cases, errors from JDBC related to database, but not for Talend

in your case it could be or missed column in the target table (Column0) or null value in not null column, more need to search in the documentation for your version of DB2

cheers