db2cmd 跑到db2目录下执行命令。
CONNECT TO MTPDB;
ALTER TABLE schema.table ADD COLUMN DFT_STIBO_PRO_EST DOUBLE;
ALTER TABLE schema.table ADD COLUMN DFT_TRANS_LAY_EST DOUBLE;
REORG TABLE schema.table ;
UPDATE schema.table SET DFT_STIBO_PRO_EST = 0.0 WHERE name='Client Presentation';
CONNECT RESET;
CONNECT TO MTPDB;
ALTER TABLE schema.table ADD COLUMN DFT_STIBO_PRO_EST DOUBLE;
ALTER TABLE schema.table ADD COLUMN DFT_TRANS_LAY_EST DOUBLE;
REORG TABLE schema.table ;
UPDATE schema.table SET DFT_STIBO_PRO_EST = 0.0 WHERE name='Client Presentation';
CONNECT RESET;