17.6.3 Specification format of field data (fixed-length format)

Specify data all in character format.

For details about the specification values for each data type, see 17.5.3 Specification format of field data (CSV format).

The following are notes about the fixed-length format that differ from the CSV format:

The method for specifying empty strings and default values for columns differs from that for the CSV format.

To specify an empty string or a default value for a column, specify data to be treated as the empty string or the default value for the column in the -c option of the adbcolumninfo operand in the column structure information options. When input data that matches the specified value is detected, the empty string or the default value is stored in the corresponding column. Note that comparison is based on the input data before unneeded spaces and tabs have been removed.

Important

If the NOT NULL constraint is defined for a column and the corresponding data in the input data contains a specification that is treated as an empty string, a logical error occurs during execution of the adbimport command.
Enclosing characters are treated as data.

If enclosing characters are not needed as data, specify the part without the enclosing characters for the start position and length in the -p option of the adbcolumninfo operand.

If enclosing characters are included as data, they need be specified in succession, unlike in the CSV format.
Variable-length data might be treated as data with a length of zero depending on the specification method. For details, see Table 17‒15: How to make the start positions uniform in 17.6.2 Coding rules for input data (fixed-length format).