Contents Index GRANT of column permission on view not allowed Host variable reference in service definition must be named

ASA Error Messages
  Database Error Messages
    Alphabetic list of error messages

Grouped query contains more than one distinct aggregate function


Item Value
SQLCODE -863
Constant SQLE_INVALID_DISTINCT_AGGREGATE
SQLSTATE 42W70
Sybase error code 13867
ODBC 2 State 37000
ODBC 3 State 42000
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.


Contents Index GRANT of column permission on view not allowed Host variable reference in service definition must be named