Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

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.
Labels (4)
1 Reply
Anonymous
Not applicable

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).