The DEFAULT constraint is used to set a default value for a column. The default value will be added to all new records, if no other value is specified. # Default constraint using CREATE table ...

The DEFAULT constraint is used to set a default value for a column. This default value is automatically assigned when no value is provided during an insert operation.

If you omit the RDBLOCK= option, the default value, RDBLOCK=NOCONCUR, is used. A table-level lock is put on the table, which means that only one user can update the table at a time. Specify ...