Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]
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