GENERATED BY DEFAULT for DB2 UDB 9.x

A generate By Default option is now available for a TIMESTAMP datatype if the column does not allow nulls (Allow Nulls? is set to No), and you have selected Generated Column.

Timestamp.png

 

The following is an example of the SQL produced for a column when these options are selected

HireDate TIMESTAMP NOT NULL GENERATED BY DEFAULT FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP.