One Star

DB2 output component error

Hi,
I tried to write a simply update in db2 by using db2 output component.
But I got the following error:
connected
Exception in component tDB2Output_1
com.ibm.db2.jcc.a.SqlException: Jdbc type 1111 not yet supported.
at com.ibm.db2.jcc.a.n.a(n.java:1003)
at com.ibm.db2.jcc.a.n.a(n.java:892)
at com.ibm.db2.jcc.a.n.a(n.java:873)
at com.ibm.db2.jcc.a.sf.b(sf.java:568)
at com.ibm.db2.jcc.a.sf.setNull(sf.java:558)
at advservice.millupdate_0_1.millupdate.tDB2Input_1Process(millupdate.java:1332)
at advservice.millupdate_0_1.millupdate.runJobInTOS(millupdate.java:1761)
at advservice.millupdate_0_1.millupdate.main(millupdate.java:1635)
disconnected
Do you know what this means?
Thanks.
1 REPLY
Employee

Re: DB2 output component error

I know it's an old post but I just experience this problemby trying to insert a NULL data in a column that is configured in the data model to NOT NULL.
Look at all your data in your dataflow (Maybe if you use a tmap a join that is not managed in inner join type).