1.执行命令报错http://www.cndba.cn/hbhe0316/article/108673http://www.cndba.cn/hbhe0316/article/108673http://www.cndba.cn/hbhe0316/article/108673

[xxx@xxx ~]$ db2 "call XXX.XXX(1,'ALL')"
SQL0407N  Assignment of a NULL value to a NOT NULL column "TBSPACEID=4,
TABLEID=22, COLNO=12" is not allowed.  SQLSTATE=23502

2.查看是哪张表

[xxx@xxx ~]$ db2 "select tabschema,tabname,tableid from syscat.tables where TABLEID='22' AND tabschema='XXX'"

TABSCHEMA        TABNAME                TABLEID
------------ -
XXX            xxx         22

3.查看是这个表的哪个column

[xxx@xx ~]$ db2 "select varchar(TABSCHEMA,10) AS TABSCHEMA,varchar(TABNAME,20) AS TABNAME,varchar(COLNAME,40) AS COLNAME,COLNO FROM SYSCAT.COLUMNS where TABNAME='XXXX'"

TABSCHEMA  TABNAME              COLNAME                                  COLNO
---------- -------------------- ---------------------------------------- ------

版权声明：本文为博主原创文章，未经博主允许不得转载。

DB2