Teradata Database Message 6928 - 17.10 - 6928 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
Recursive queries must begin with at least one non-recursive SELECT.
Explanation
The first SELECT of recursive query/view's body must not contain a recursive reference.
Generated By
RES modules
For Whom
End User
Notes
None
Remedy
Examine the SQL statement and verify that the request is correct. If there is already a non-recursive SELECT in the body of the query/view, move that SELECT to the top of the set operation. If not, then rewrite the statement to adhere to the recursive query rules and resubmit the request.