KFAA30464-E

The specification of the recursive query is invalid.

aa....aa: Cause of the error

• an anchor member is not specified, or an anchor member is not specified before a recursive member:

  An anchor member is not specified. Alternatively, all anchor members are not specified before a recursive member. <SQLSTATE: 427N5>

• the recursive query name is specified in a subquery:

  A recursive query name is specified in a subquery. <SQLSTATE: 427N6>

• the recursive member is not specified in an operand of a UNION ALL set operation:

  UNION ALL is not specified as the set operation for the recursive member. <SQLSTATE: 427N7>

• the last anchor member specified and the first recursive member specified are not specified in the operands of a UNION ALL set operation:

  UNION ALL is not specified as the set operation for the last specified anchor member and the first specified recursive member. <SQLSTATE: 427N8>

bb....bb:

List number of the WITH list element corresponding to the recursive query

S:

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

Action:

Correct the SQL statement.