The project died on the vine and I just found out that my online reorg script has been failing with this error.
DW_LASTTIME TIMESTAMP NOT NULL GENERATED BY DEFAULT FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP
I can't start doing offline reorgs due to the nature of the business so I would like to change that column to just a regular timestamp or date or varchar.
Online Reorg fails with SQL2219N Reason code: "13" https://www.ibm.com/support/pages/online-reorg-fails-sql2219n-reason-code-13
But when I try I get
ALTER table TESTTABLE ALTER COLUMN DW_LASTTIME SET DATA TYPE VARCHAR(30);
I know I can drop it but I was trying to be less intrusive. Is there any way to change this sort of dropping the column?
ERROR  [IBM][DB2/NT64] SQL0190N ALTER TABLE "AE" specified attributes for column "DW_LASTTIME" that are not compatible with the existing column.
Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>