首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > 其他数据库 >

DB2 SQL0407N : Assignment of a NULL value to a NOT NULL column “TBSPACEID=二, TAB

2013-08-27 
DB2 SQL0407N : Assignment of a NULL value to a NOT NULL column “TBSPACEID2, TAB.Posted on?December

DB2 SQL0407N : Assignment of a NULL value to a NOT NULL column “TBSPACEID=2, TAB

.Posted on?December 1, 2008?by?nitingautam

SQL0407N Assignment of a NULL value to a NOT NULL column name is not allowed.

If you encounter this error and If the value for name is of the form “TBSPACEID=n1, TABLEID=n2, COLNO=n3”, you can determine the table name and column name using the following query:

?

?
SELECT C.TABSCHEMA,
C.TABNAME, C.COLNAME FROM SYSCAT.TABLES AS T,
SYSCAT.COLUMNS AS C WHERE
T.TBSPACEID = 2 AND  T.TABLEID = 26 AND  C.COLNO = 0 AND
C.TABSCHEMA = T.TABSCHEMA AND  C.TABNAME = T.TABNAME

?

热点排行