Hitachi

Hitachi Advanced Database Messages


KFAA31470-E

The aa....aa is specified in the recursive member. (with list number = bb....bb, query number = cc....cc) (M+J+O)

aa....aa is specified in the recursive member. <SQLSTATE: 427N0>

aa....aa: Item that cannot be specified
  • SELECT DISTINCT: SELECT DISTINCT

  • "GROUP BY" clause: GROUP BY clause

  • "HAVING" clause: HAVING clause

  • "LIMIT" clause: LIMIT clause

  • set function: Set function

  • LEFT OUTER JOIN: LEFT OUTER JOIN

  • RIGHT OUTER JOIN: RIGHT OUTER JOIN

  • FULL OUTER JOIN: FULL OUTER JOIN

  • more than one recursive query name: Multiple recursive query names

bb....bb:

List number of the WITH list element for which the recursive member is specified

cc....cc: Position number of the query that specified predicate aa....aa

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

If aa....aa is "LIMIT" clause and the LIMIT clause is specified in the query expression body that contains the set operation, the position number of the first query specification in the query expression body is displayed.

S:

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

Action:

Correct the SQL statement.