首页 > 技术文章 > ERROR [23502] [IBM][DB2/NT64] SQL0407N 不允许对 NOT NULL 列 "TBSPACEID=8, TABLEID=49, COLNO=8" 赋予空值。

AbelAngelo 2020-06-11 14:11 原文

SELECT C.TABSCHEMA,
C.TABNAME, C.COLNAME FROM SYSCAT.TABLES AS T,
SYSCAT.COLUMNS AS C WHERE
T.TBSPACEID = 8 AND T.TABLEID = 49 AND C.COLNO = 8 AND
C.TABSCHEMA = T.TABSCHEMA AND C.TABNAME = T.TABNAME

推荐阅读