Error 890

"Statement size or complexity exceeds server limits"

Item Description

SQLCode

-890L

Constant

SYNTACTIC_LIMIT

SQLState

54W01

ODBC 2 State

37000

ODBC 3 State

54000

Sybase Error Code

2553

Severity Code

19

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.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com