`
jiaoronggui
  • 浏览: 1298997 次
  • 性别: Icon_minigender_1
  • 来自: 合肥
博客专栏
B7c2eb31-a8ea-3973-a517-d00141f39b89
项目管理软件-redmin...
浏览量:114997
4a63e153-250f-30f6-a051-97cfc67cb3d3
IT职业规划
浏览量:197375
社区版块
存档分类
最新评论

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

    博客分类:
  • DB2
 
阅读更多

.

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

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics