When changing a column name from PMT_RCVD_DT to PMT_RCVD_TS and its attribute from DATE to TIMESTAMP, the ddl should have come as follows:
"ALTER TABLE PODDB01.CLNT_PMT RENAME COLUMN PMT_RCVD_DT TO PMT_RCVD_TS; ALTER TABLE PODDB01.CLNT_PMT ALTER COLUMN PMT_RCVD_TS SET DATA TYPE TIMESTAMP; REORG TABLE PODDB01.CLNT_PMT."
Instead we get DROP and RECREATE
Workaround:
None
Status:
Waiting for fix in future release of Toad for DB2.
© ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center