Hitachi

Hitachi Advanced Database Messages


KFAA31201-E

The grouping column name for the grouping specification that specified "AS column name" cannot be referenced from a subquery in a aa....aa. (M+J+O)

If AS column-name is specified in the GROUP BY clause, the grouping column name cannot be referenced from a subquery in aa....aa. <SQLSTATE: 427I5>

aa....aa: Location of specification in which the error occurred
  • "HAVING" clause: HAVING clause

  • selection expression: Selection expression

S:

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

Action:

Correct the SQL statement.