DB2 SQL-Error: -346
SQLState: 42836
Short Description: AN INVALID REFERENCE TO COMMON TABLE EXPRESSION OCCURS IN THE FIRST FULLSELECT AS A SECOND OCCURRENCE IN THE SAME FROM CLAUSE OR IN THE FROM CLAUSE OF A SUBQUERY C FROM FROM
The common table expression name includes an invalid reference to itself as described by one of the following: v A recursive reference in the first fullselect before the UNION ALL set operator. The first fullselect must be an initialization and cannot include a recursive reference. v More than one reference to the same common table expression in the same FROM clause. Such references are not permitted in recursive common table expression. v A recursive reference in the FROM clause of a subquery. A recursion cycle cannot be defined using a subquery.System action: The statement cannot be executed. Programmer response: Change one of the following: v the fullselect prior to the union operator so that it does not include a recursive reference.