error message:
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=31, TABLEID=69, COLNO=3" is not allowed. SQLSTATE=23502
solution:
SELECT tabschema, tabname, colnameFROM syscat.columnsWHERE colno = 3 AND( tabschema, tabname ) IN( SELECT tabschema, tabnameFROM syscat.tablesWHERE tbspaceid =31 ANDtableid = 69 )
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment