我先是修改了语句:如下
alter table "YWYQ"."BUSINESS_INFO" alter "SHOW_IMAGE" DROP NOT NULL;
后面查询表的时候报错
SELECT * FROM YWYQ.BUSINESS_INFO
ERROR [57016] [IBM][DB2/NT64] SQL0668N Operation not allowed for reason code "7" on table "YWYQ.BUSINESS_INFO".
原因是更新/修改表结构之后,当前的表不活动了
需要执行以下代码:
CALL SYSPROC.ADMIN_CMD('reorg table YWYQ.BUSINESS_INFO');
此文章仅为补坑