Hitachi

Hitachi Advanced Database Messages


KFAA30323-E

The specification of the multiset value expression is invalid. (reason = aa....aa, query number = bb....bb) (M+J+O)

The specified multiset value expression is invalid.

aa....aa: Cause of the error
  • a subquery of a multiset value expression is a correlated subquery: An external reference column cannot be specified in a table subquery of a multiset value expression. <SQLSTATE: 427I9>

  • data types are not all comparable: The data type of data specified for the multiset element is not comparable. <SQLSTATE: 427IA>

bb....bb: Query position number

For details about query position numbers, see 1.5 Query position numbers.

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Correct the SQL statement.