KFAA50222-E
The input data contains an invalid empty string. (input file = aa....aa, row = bb....bb, column = cc....cc) (M)
An empty string is specified in field number cc....cc in the bb....bbth row, which cannot store a null value.
- 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.
-
- 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:
-
Surround array type field data with enclosing characters
-
Re-execute the adbimport command.
-
If a logical error occurs in the input data, follow the instructions in the output error message and fix the error.
-