With DB2 V4.1, users can define default values for table columns other than the standard defaults of zero, spaces, a date of 0001-01-01, etc. In addition, the column for which the default is defined does not need to be NOT NULL.

The default values are used as follows: