15.00 - 5816 DISTINCT on SET operation must be on a column reference. - 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)

5816 DISTINCT on SET operation must be on a column reference.

Explanation:

AVG, MAX, MIN, SUM or COUNT has specified DISTINCT and has an argument that is not a column reference.

Generated By:

ResName module.

For Whom:

User.

Remedy:

If script is to be full ANSI compliant, change the indicated statement.