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

SQL Anywhere 11.0.0 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (L-S)

 

Statement size or complexity exceeds server limits

Error constant SQLE_SYNTACTIC_LIMIT
ODBC 2 State 37000
ODBC 3 State 54000
Severity 19
SQLCODE –890
SQLSTATE 54W01
Sybase error code 404
Probable cause

The statement contains one or more constructs whose size make it impossible to process. Increasing the maximum cache size, page size, or stack size may resolve this error. Consider rewriting the query so that the internal limit is not exceeded. For example, if the query contains a large IN-list, consider inserting the IN-list's values into a temporary table. Then rewrite the query to join this temporary table to the other table(s) in the original statement.