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

ganeshK — Mon, 22 Jun 2020 07:56:45 GMT

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]

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

vapukov — Thu, 25 Jun 2020 04:28:58 GMT

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

topic Re: DB2 Insert Error : SQLCODE: -206, SQLSTATE: 42703, SQLERRMC: Column0 in Talend Studio

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

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