Nonstop Database, HiRDB Version 9 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 | 5.4.2(6) | column-name statement | 5.7.1 |
| Some of the input data is not to be stored in the table | -c | skipdata statement | 5.7.2 | |
| Information about a constructor function is specified to generate values for the abstract data type columns | -c | column-name statement | 5.7.1 | |
| Separator used in the input data is not a comma (,) | -s | 5.4.2(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.16 |
| 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.16 |
The input data file in DAT format satisfies one of the following conditions:
|
-- | -- | extdat statement | 5.4.13 |
| Data containing a decimal point is to be stored in INTEGER and SMALLINT columns | -- | -- | extdat statement | 5.4.13 |
--: 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 | 5.4.2(6) | column-name statement | 5.7.1 |
| Some of the input data is not to be stored in the table# | -c | 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 | 5.4.2(7) | 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.16 |
--: 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 | 5.4.2(6) | column-name statement | 5.7.1 |
| Some of the input data is not to be stored in the table | -c | 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 | 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.16 |
--: Not applicable
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.