Hitachi

Hitachi Advanced Database Messages


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.