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 )
Showing posts with label tbspaceid. Show all posts
Showing posts with label tbspaceid. Show all posts
Thursday, May 15, 2008
Subscribe to:
Posts (Atom)