Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (T-Z)

 

Window function used in predicate

Error constant SQLE_ILLEGAL_WINDOW_PREDICATE
ODBC 2 State ERROR
ODBC 3 State ERROR
Severity 16
SQLCODE –964
SQLSTATE 42WA8
Sybase error code 13526
Probable cause

A window function was used in the WHERE or HAVING clause of a SELECT statement. Consider making the SELECT into a derived table, putting the window function in the select list of the derived table, and changing the predicate to reference the derived column.