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
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center