DB2: Alter a column
db2 set current schema wcs; db2 "ALTER TABLE XGCPTMWUNIVERSEPRODUCT ALTER COLUMN MAXHEMLENGTH SET DATA TYPE DECIMAL (8,4)"; db2 reorg table XGCPTMWUNIVERSEPRODUCT inplace; OR For exclusive access: db2 reorg table XGCPTMWUNIVERSEPRODUCT classic allow no access;