DB2-407错误快速检测

识别哪些字段不允许为空

错误提示：DB2 SQL 错误：SQLCODE=-407，SQLSTATE=23502，SQLERRMC=TBSPACEID=2，TABLEID=1284，COLNO=31，DRIVER =4.21.29

处理方式：①执行语句 SELECT * FROM SYSCAT.TABLES WHERE TBSPACEID='2' AND TABLEID = '1284';
②执行语句 SELECT * FROM SYSCAT.COLUMNS WHERE TABSCHEMA = 'CMS3' AND TABNAME = 'TC_INVENTORY_ITEM' AND COLNO = '31';

colname中所传递的字段内容为空。