KFAA30464-E
The specification of the recursive query is invalid. (reason = aa....aa, with list number = bb....bb) (M+J+O)
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.