启动DB2
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;
页:
[1]