Teradata Database Message 6920 - 6920 - Analytics Database - Teradata Vantage

Message

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

Notes

None

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.