Scalable Database Server, HiRDB Version 8 Command Reference

[Contents][Index][Back][Next]

5.3.3 Information to be specified depending on the type of input data file

Organization of this subsection
(1) DAT format
(2) Binary format
(3) Fixed-size data format

(1) DAT format

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) [Figure] [Figure]
Code for a space is to be converted in the national character string or mixed character string type input data [Figure] [Figure] 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 [Figure] [Figure] option statement 5.4.15
The input data file in DAT format satisfies one of the following conditions:
  • Data to be stored contains linefeed codes or NULL characters.
  • Character data is enclosed by a character that is not the double quotation mark (").
[Figure] [Figure] extdat statement 5.4.12
Data containing a decimal point is to be stored in INTEGER and SMALLINT columns [Figure] [Figure] extdat statement 5.4.12

[Figure]: Not applicable

(2) Binary format

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 [Figure] [Figure] option statement 5.4.15

[Figure]: Not applicable

* Applicable if the input data file was created by pdrorg and data loading is to be on a non-FIX table.

(3) Fixed-size data format

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 [Figure] [Figure] 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 [Figure] [Figure] option statement 5.4.15

[Figure]: Not applicable