db2 removal of Generate always Expression on Timestamp data type

Question

I have a column UPDATE_TIME with an expression

 TIMESTAMP NOT NULL GENERATED ALWAYS FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP

How to remove the Generated always for timestamps?

I tried

  db2 "alter table xxxx alter column UPDATE_TIME drop expression" 

Answer 1

This is not valid syntax. You need to use,

 alter table xxxx alter column update_time drop generated

See the documentation on alter table for more details.