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

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

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;
1 Like