15.00 - 5895 A function, operator, or expression involving the SELECT AND CONSUME statement is invalid. - 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)

5895 A function, operator, or expression involving the SELECT AND CONSUME statement is invalid.

Explanation:

A function, operator, or expression involving the SELECT AND CONSUME statement is invalid for one of the following reasons: - an aggregate (e.g., SUM, COUNT) function is specified, - an ordered analytical function is specified, - a UNION set operator is specified, - a MINUS/EXCEPT operator is specified, - a INTERSECT operator is specified.

Generated By:

Resolver modules.

For Whom:

End User.

Remedy:

Remove the invalid expression from the SELECT AND CONSUME statement and resubmit the statement.