Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

GRANT of column permission on view not allowed Next Page

Grouped query contains more than one distinct aggregate function

Item

Value

Constant

SQLE_INVALID_DISTINCT_AGGREGATE

ODBC 2 State

37000

ODBC 3 State

42000

Severity

15

SQLCODE

-863

SQLSTATE

42W70

Sybase error code

13867

Probable cause

Two or more DISTINCT aggregate functions were specified in the same grouped query. This is only permitted if the Hash Group By operator is available. Any query block can only contain at most one DISTINCT aggregate function if the Hash Group By operator is not available.