6920 A non-recursive WITH clause or view should not reference itself within its own definition.
Explanation:
A query name or relation is being referenced inside its own definition, which is not allowed. This could be a non-recursive WITH clause or a CREATE VIEW statement.
Generated By:
SYN/RES modules
For Whom:
End User
Remedy:
Examine the SQL statement and verify that the request is correct. Convert the statement into a recursive statement by using a WITH RECURSIVE or CREATE RECURSIVE VIEW clause if the query name needs to be referenced in its own definition. Otherwise, remove the query name reference from the non-recursive WITH or VIEW definition and resubmit the request.