KFAA50220-E

An error occurred during input data conversion.

Information about where the error occurred is output for aa....aa to dd....dd.

aa....aa:

The serial number or file name of the input file

bb....bb:

Row number

cc....cc: Field number

• If the input data is in the CSV format: Field data number

• If the input data is in a fixed-length format: Order of the column definition in the table definition

  The columns indicated by the order of column definition in the table definition correspond to the columns specified in the -n option of the adbcolumninfo operand in the column structure information file. The value in the -p option, specified along with the -n option, corresponds to the relevant part of the input data.

dd....dd: Element number of array element

• If an error occurs with array type field data:

  The element number of the array element in which the error occurred is displayed.

  However,0 is displayed if the error occurs in a non-array element, such as "a" instead of {"a"}, which is not enclosed in curly brackets.

• If an error occurs with non-array type field data:

  0 is displayed.

S:

Terminates processing.

Action:

A logical error has occurred in input data. For details about the corrective action to take, see How to handle logical errors in input data in the manual HADB Command Reference.

Also, for details about the process up to executing the adbimport command, see Handling abnormal termination of the adbimport command in the manual HADB Command Reference.

<When the table to be imported has an array-type column defined>

Check whether the array type field data is surrounded by enclosing characters.

• If the array type field data is not surrounded by enclosing characters

  It is possible that an array element in the array type field data tried to be imported into a non-array type column, resulting in a logical error in the input data. In this case, use the following procedure:

  1. Surround array type field data with enclosing characters

  2. Re-execute the adbimport command.

  3. If a logical error occurs in the input data, follow the instructions in the output error message and fix the error.

• When array type field data is surrounded by enclosing characters

  It is possible that an attempt to import array type field data into a non-array type column resulted in a logical error in the input data. In this case, use the following procedure:

  1. Check the input data in bb....bb-th line and correct the input data file

     Correct the input data file so that array type field data is imported into array-type columns. If all lines have similar errors, specify the adbimport command with the -r option so that the array type field data is imported into the array-type column.

  2. Re-execute the adbimport command.