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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center