Hitachi

Hitachi Advanced Database Messages


KFAA31255-E

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

Structure data cannot be specified in aa....aa. <SQLSTATE:427MC>

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 in statements other than COPY and CREATE VIEW:

    Selection expression for the outermost query specification (except in the COPY and CREATE VIEW statements)

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

  • 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.