报错
SQLCODE=-407, SQLSTATE=23502, SQLERRMC=TBSPACEID=5, TABLEID=30, COLNO=0, DRIVER=3.50.152
解决方法
根据报错信息,把实例名,表名,colno填入就可知道哪个字段出错
select * from syscat.columns where tabschema = 'DB2INST1' and TABNAME = 'T_RECEIPT_MONTH_RECODE' AND COLNO = '0'
报错
SQLCODE=-407, SQLSTATE=23502, SQLERRMC=TBSPACEID=5, TABLEID=30, COLNO=0, DRIVER=3.50.152
解决方法
根据报错信息,把实例名,表名,colno填入就可知道哪个字段出错
select * from syscat.columns where tabschema = 'DB2INST1' and TABNAME = 'T_RECEIPT_MONTH_RECODE' AND COLNO = '0'