Hitachi

Hitachi Advanced Database Command Reference


17.5.1 CSV format specifications

In CSV format, item data is separated by delimiters. The delimited item data is called field data. The following figure shows an example of the CSV format.

Figure 17‒16: Example of the CSV format

[Figure]

Explanation:
  • Each row of data in an input data file corresponds to a row of data in the table.

  • The field data items to be entered in the input data files need not be in the same order in which the columns appear in the table.

  • Use the character encoding specified in the ADBLANG environment variable to create the input data file.

  • If field data is enclosed in enclosing characters, specify the enclosing character in the -k option of the adbimport command.

  • Demarcate the field data items with a delimiter. Specify this delimiter in the -s option of the adbimport command.

  • Use the same format as for character string data to represent numeric values, such as age.