KFAA30324-E
The specified argument in the system-defined function "ADB_CSVREAD" is invalid. (argument number = aa....aa, option = bb....bb, reason = cc....cc, query number = dd....dd) (M+J+O)
The argument specified in the ADB_CSVREAD function is invalid.
- aa....aa:
-
Position number of the argument
- bb....bb: Function option that caused the error
-
-
compression_format: Compression format option
-
field_num: Specification column option
-
binary_string_format: Binary string format option
-
enclosing_char: Enclosing character specification option
-
delimiter_char: Delimiting character specification option
-
***: Items other than the above
-
- cc....cc:
-
Cause of the error
- dd....dd: Query position number
-
For details about query position numbers, see 1.5 Query position numbers.
The following describes the causes of the error.
No. |
Value of aa....aa |
Value of bb....bb |
Value of cc....cc |
Cause of the error |
SQLSTATE |
---|---|---|---|---|---|
1 |
1 |
*** |
data type is incorrect |
The data type of an element of the multiset value expression specified in the first argument is invalid. |
427J0 |
2 |
2 |
*** |
option format is incorrect |
The specification format of the function option is invalid. |
427J1 |
3 |
2 |
*** |
option is duplicated |
The function option is specified more than once. |
427J2 |
4 |
2 |
compression_format |
option is missing |
A function option that cannot be omitted is not specified. |
427J3 |
5 |
2 |
compression_format |
value is incorrect |
The value specified in the function option is invalid. |
427J4 |
6 |
2 |
field_num |
|||
7 |
2 |
binary_string_format |
|||
8 |
2 |
enclosing_char |
|||
9 |
2 |
delimiter_char |
|||
10 |
2 |
field_num |
field data number is duplicated |
The field data number is specified more than once. |
427J5 |
11 |
2 |
binary_string_format |
|||
12 |
2 |
field_num |
over specified num |
The number of specified field data numbers exceeds the upper limit. |
427J6 |
13 |
2 |
field_num |
the number of field_num numbers is not the same as the number of columns in the table function column list |
The number of field data numbers is different from the number of columns in the table function column list corresponding to the table function derived table. |
427J7 |
14 |
2 |
binary_string_format |
the value for the binary_string_format option is not specifiable for a field_num option |
The field data number specified in the binary string format option is invalid. Select a field data number from those specified in the specification column option. |
427J8 |
15 |
2 |
binary_string_format |
only a number corresponding to a binary data type column can be specified for the field data number |
The field data number specified in the binary string format option is invalid. The field data specified for the field data number is not binary type data. |
427J9 |
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
Correct the SQL statement.