Teradata Database Message 6928 - 6928 - Analytics Database - Teradata Vantage

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.