If INCLUDING IDENTITY is not specified, the table will not have an identity column.
Do not specify INCLUDING COLUMN DEFAULTS, if you specify USING TYPE DEFAULTS.
If INCLUDING COLUMN DEFAULTS is not specified, the default values are not inherited.
Data type | Default value |
---|---|
Numeric | 0 |
Fixed-length character or graphic string | Blanks |
Fixed-length binary string | Hexadecimal zeros |
Varying-length string | A string length of 0 |
Date | The current date at the time of INSERT |
Time | The current time at the time of INSERT |
Timestamp | The current timestamp at the time of INSERT |
Datalink | A value corresponding to DLVALUE('','URL','') |
distinct-type | The default value of the corresponding source type of the distinct type. |
Do not specify USING TYPE DEFAULTS if INCLUDING COLUMN DEFAULTS is specified.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.