How to set timestamp for each row on update as row change in DB2 via liquibase

Community Answers
1

ALTER TABLE tablename ALTER COLUMN modifieddate SET TIMESTAMP FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP NOT NULL

How to achieve this via liquibase script? #db2 #liquibase-users #uncategorized

2

Why not just use sql format:

--liquibase formatted sql

--changeset author:id
ALTER TABLE tablename ALTER COLUMN modifieddate SET TIMESTAMP FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP NOT NULL;