Scalable Database Server, HiRDB Version 8 Command Reference
For details about an applicable item, see the section indicated.
| Item | Reference target | |||
|---|---|---|---|---|
| Option | Control statement | |||
| There is no correspondence between input data and table columns | -c | (7) | column name statement | 5.7.1 |
| Some of the input data is not to be stored in the table | -c | (7) | skipdata statement | 5.7.2 |
| Information about a constructor function is specified to generate values for the abstract data type columns | -c | (7) | column name statement | 5.7.1 |
| Separator used in the input data is not a comma (,) | -s | (12) | ||
| Code for a space is to be converted in the national character string or mixed character string type input data | option statement | 5.4.15 | ||
| If the input data to be stored in character string or BINARY type column is longer than the defined column length, an input data error is to be detected | option statement | 5.4.15 | ||
The input data file in DAT format satisfies one of the following conditions:
|
extdat statement | 5.4.12 | ||
| Data containing a decimal point is to be stored in INTEGER and SMALLINT columns | extdat statement | 5.4.12 | ||
: Not applicable
For details about an applicable item, see the section indicated.
| Item | Reference target | |||
|---|---|---|---|---|
| Option | Control statement | |||
| There is no correspondence between input data and table columns* | -c | (7) | column name statement | 5.7.1 |
| Some of the input data is not to be stored in the table* | -c | (7) | skipdata statement | 5.7.2 |
| Input data is converted to a null value, or information about a constructor function is specified to generate values for the abstract data type columns | -v | (8) | column number statement | 5.8.1 |
| Code for a space is to be converted in the national character string or mixed character string type input data | option statement | 5.4.15 | ||
: Not applicable
* Applicable if the input data file was created by pdrorg and data loading is to be on a non-FIX table.
For details about an applicable item, see the section indicated.
| Item | Reference target | |||
|---|---|---|---|---|
| Option | Control statement | |||
| There is no correspondence between input data and table columns | -c | (7) | column name statement | 5.7.1 |
| Some of the input data is not to be stored in the table | -c | (7) | skipdata statement | 5.7.2 |
| Input data is converted to a null value, or information about a constructor function is specified to generate values for the abstract data type columns | -c | (7) | column name statement | 5.7.1 |
| The double quotation mark (") is to be stored as input data | column name statement | 5.7.1 | ||
| Code for a space is to be converted in the national character string or mixed character string type input data | option statement | 5.4.15 | ||
: Not applicable
All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.