Hi,
I am loading data to a DB2 table using tDB2Output componet. In my target table already some data is present and I want to truncate the data before loading. In tDB2Output componet I have selected "Clear data in table". If I am correct, it will truncate the existing data table before loading new data. But I am getting following error if I use "Clear data in table".
I am using Java version.
Exception in component tDB2Output_1
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -964, SQLSTATE: 57011, SQLERRMC: null
at com.ibm.db2.jcc.a.rf.e(rf.java:1680)
at com.ibm.db2.jcc.a.rf.b(rf.java:1207)
at com.ibm.db2.jcc.b.jb.i(jb.java:224)
at com.ibm.db2.jcc.b.jb.b(jb.java:50)
at com.ibm.db2.jcc.b.w.b(w.java:36)
at com.ibm.db2.jcc.b.cc.f(cc.java:149)
at com.ibm.db2.jcc.a.rf.m(rf.java:1204)
at com.ibm.db2.jcc.a.rf.a(rf.java:1984)
at com.ibm.db2.jcc.a.rf.c(rf.java:566)
at com.ibm.db2.jcc.a.rf.executeUpdate(rf.java:551)
at test_java.demo_staging_load.Demo_Staging_Load.tFileInputDelimited_1Process(Demo_Staging_Load.java:516)
at test_java.demo_staging_load.Demo_Staging_Load.runJob(Demo_Staging_Load.java:2316)
at test_java.demo_staging_load.Demo_Staging_Load.main(Demo_Staging_Load.java:2260)
Can any body suggest me how to truncate the data before loading new data?
