17.8 Value that is stored for empty-string input data
The table below shows the actual value that is stored in the target column when input data is the empty string.
If input data is not the empty string, the value of that input data is always stored regardless of the specification made during table definition and the value of the adb_import_null_string import option.
|
No. |
Specification made in the table definition |
Value of the adb_import_null_string import option |
Actual value that is stored |
|
|---|---|---|---|---|
|
NOT NULL constraint |
DEFAULT clause |
|||
|
1 |
Not specified. |
Not specified. |
DEFAULT, or the option was omitted. |
Null value |
|
2 |
NULL |
Null value |
||
|
3 |
Specified. |
DEFAULT, or the option was omitted. |
Default value of the column# |
|
|
4 |
NULL |
Null value |
||
|
5 |
NOT NULL |
Not specified. |
DEFAULT, or the option was omitted. |
-- |
|
6 |
NULL |
-- |
||
|
7 |
Specified. |
DEFAULT, or the option was omitted. |
Default value of the column# |
|
|
8 |
NULL |
-- |
||
- Legend:
-
--: No value is stored because a logical error results.
- #
-
For details about the default values of columns, see the following topics:
• Specification format and rules for the CREATE TABLE statement in CREATE TABLE (define a table) in Definition SQL in the manual HADB SQL Reference
• Setting a default value for a column (DEFAULT clause) in Designing a table in Designing a Database in the HADB Setup and Operation Guide