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.
When WITH REPLACE is not specified, then the name specified must not identify a declared global temporary table that already exists in the current session.
The ON COMMIT clause does not apply if the declared global temporary table is opened under isolation level No Commit (NC) or if a COMMIT HOLD operation is performed.
The ON ROLLBACK clause does not apply if the declared global temporary table was opened under isolation level No Commit (NC) or if a ROLLBACK HOLD operation is performed.
If a record format name is not specified, the format-name is the same as the system-object-name of the table.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.