When trying to retrieve data from a DB2 database (version 11.1, fix pack 2) with tDB2Input, I get the error message below although I successfully found the tables in the db2 connection and added them to the belonging repository.
Since I am still testing this connection, I am working in the talend studio and trying to run the job locally in the first place. DB2RIM ist the user, "/BIC/AYSPRD0700" is the table name. Since it work with SISS, it ought to work with talend as well.
Many thanks in advance!
Exception in component tDBInput_1 (DB2_P32_Test)
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2RIM./BIC/AYSDPRD0700, DRIVER=4.23.42
at com.ibm.db2.jcc.am.ld.a(ld.java:810)
at com.ibm.db2.jcc.am.ld.a(ld.java:66)
at com.ibm.db2.jcc.am.ld.a(ld.java:140)
at com.ibm.db2.jcc.am.aq.c(aq.java:2807)
at com.ibm.db2.jcc.am.aq.d(aq.java:2791)
at com.ibm.db2.jcc.am.aq.a(aq.java:2217)
at com.ibm.db2.jcc.t4.bb.i(bb.java:192)
at com.ibm.db2.jcc.t4.bb.b(bb.java:83)
at com.ibm.db2.jcc.t4.p.a(p.java:32)
at com.ibm.db2.jcc.t4.vb.i(vb.java:150)
at com.ibm.db2.jcc.am.aq.lb(aq.java:2186)
at com.ibm.db2.jcc.am.aq.a(aq.java:3312)
at com.ibm.db2.jcc.am.aq.a(aq.java:722)
at com.ibm.db2.jcc.am.aq.executeQuery(aq.java:701)
at codecommit_bicc_projekt_01.db2_p32_test_0_1.DB2_P32_Test.tDBInput_1Process(DB2_P32_Test.java:2373)
at codecommit_bicc_projekt_01.db2_p32_test_0_1.DB2_P32_Test.runJobInTOS(DB2_P32_Test.java:3739)
at codecommit_bicc_projekt_01.db2_p32_test_0_1.DB2_P32_Test.main(DB2_P32_Test.java:3565)
[FATAL]: codecommit_bicc_projekt_01.db2_p32_test_0_1.DB2_P32_Test - tDBInput_1 DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2RIM./BIC/AYSDPRD0700, DRIVER=4.23.42
