I have a table with a ROW CHANGE TIMESTAMP column on it that was defined as GENERATED BY DEFAULT. Is there anyway to alter this column and change it to GENERATED ALWAYS? I thought the following might do it:
ALTER TABLE "TDKGROUP"
ALTER COLUMN "SYS_GEN_TMSTMP" SET GENERATED ALWAYS;
But I received the following:
DSNT408I SQLCODE = -20180, ERROR: COLUMN SYS_GEN_TMSTMP IN TABLE
ASLDB2.TDKGROUP CAN NOT BE ALTERED AS SPECIFIED
I think this alter may only work on generated identity columns. Any suggestions? I'm trying to avoid dropping the table.