15.00 - 6925 Unsupported use of DISTINCT inside a recursive query/view. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Language
English (United States)
Last Update
2018-09-24

6925 Unsupported use of DISTINCT inside a recursive query/view.

Explanation:

A DISTINCT clause is being used inside the recursive statement of a recursive query/view, which is not allowed.

Generated By:

SYN/OPT modules

For Whom:

End User

Remedy:

Examine the SQL statement and verify that the request is correct. Remove the DISTINCT modifier from the recursive statement and resubmit the request.