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.

ItemReference target
OptionControl statement
There is no correspondence between input data and table columns-c(7)column name statement5.7.1
Some of the input data is not to be stored in the table-c(7)skipdata statement5.7.2
Information about a constructor function is specified to generate values for the abstract data type columns-c(7)column name statement5.7.1
Separator used in the input data is not a comma (,)-s(13)[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 statement5.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[Figure][Figure]option statement5.4.16
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 statement5.4.13
Data containing a decimal point is to be stored in INTEGER and SMALLINT columns[Figure][Figure]extdat statement5.4.13

[Figure]: Not applicable

(2) Binary format

For details about an applicable item, see the section indicated.

ItemReference target
OptionControl statement
There is no correspondence between input data and table columns*-c(7)column name statement5.7.1
Some of the input data is not to be stored in the table*-c(7)skipdata statement5.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 statement5.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 statement5.4.16

[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.

ItemReference target
OptionControl statement
There is no correspondence between input data and table columns-c(7)column name statement5.7.1
Some of the input data is not to be stored in the table-c(7)skipdata statement5.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 statement5.7.1
The double quotation mark (") is to be stored as input data[Figure][Figure]column name statement5.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 statement5.4.16

[Figure]: Not applicable