15.00 - 6921 A recursive query/view definition should not contain more than one recursive relation reference in each FROM clause. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

6921 A recursive query/view definition should not contain more than one recursive relation reference in each FROM clause.

Explanation:

Recursive relation is being referenced more than once in the FROM clause in the recursive query/view, which is not allowed.

Generated By:

SYN/RES modules

For Whom:

End User

Remedy:

Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the recursive query rules and resubmit the request.