Alphabetic list of error messages
794
Function or column reference to ’%1’ in the select list must also
appear in a GROUP BY
Item Value
SQLCODE -149
Constant SQLE_INVALID_GROUP_SELECT
SQLSTATE 53003
Sybase error code 7321
ODBC 2 State 37000
ODBC 3 State 42000
Parameter 1 Name of the column referenced directly, or in an
expression, that must be in the GROUP BY clause.
You used a non-aggregate function or column reference in the select list that
does not appear in the GROUP BY clause. In a query using GROUP BY,
select list items that are not aggregate functions must also appear in the
GROUP BY clause. If the select list item is a column reference or an alias,
you may add the column name or alias to the GROUP BY clause. If the
select list item is a scalar function, ensure that the function’s arguments in the
GROUP BY clause match exactly with those in the select list. In some cases,
you may want to use the MAX function on the column name (or another
aggregate function) instead of adding the column to the GROUP BY clause.
GRANT of column permission on view not allowed
Item Value
SQLCODE -635
Constant SQLE_NO_COLUMN_PERMS_FOR_VIEWS
SQLSTATE 52W22
Sybase error code 102
ODBC 2 State ERROR
ODBC 3 State ERROR
You cannot grant permissions on columns for views.
Probable cause
Probable cause
To Next Page
Loading...