Hitachi

Hitachi Advanced Database Messages


KFAA30183-E

Array data cannot be specified in aa....aa. (query number = bb....bb) (M+J+O)

Array data cannot be specified in aa....aa. <SQLSTATE:42755>

aa....aa: Invalid specification
  • sort key: Sort key

  • select expression of the outermost query for a set operation:

    Selection expression of the outermost query specification for a set operation

  • select expression of the outermost query specification (limited to array data whose element data type is array-type or struct-type) in statements other than COPY and CREATE VIEW:

    Selection expression of the outermost query specification (other than COPY and CREATE VIEW statements)

    Array data whose element data type is array type or STRUCT type cannot be specified in a selection expression.

  • select expression of scalar subquery: Selection expression of scalar subquery

  • select expression of query expression body for INSERT statement: Selection expression of the query expression body of an INSERT statement

  • grouping column: Grouping column

  • row value constructor element: Row value constructor element

  • IN predicate: An IN predicate

  • QUANTIFIED predicate: A quantified predicate

  • CASE expression: A CASE expression

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.