Generate timestamp column

djna01 · November 8, 2020, 6:42am

DB2 has the capability to generate a timestamp column when a row is changed.

TS_COL TIMESTAMP FOR EACH ROW ON UPDATE AS ROW CHANGE

Is there any way to express this in the Visual Paradigm model so that when I generate the Database I get the timestamp column?

Jick · November 9, 2020, 2:00am

Hi djna01,

Thank you for your post. I have forwarded your question to our engineers. When I have got a reply, I will post again.

Best regards,
Jick Yeung

Jick · November 9, 2020, 7:23am

Hi djna01,

For additional DDL generation for non-supported feature, please specify the DDL clauses in column specification window.

Best regards,
Jick Yeung