Error 858

"CREATE/DROP STATISTICS statement cannot refer to virtual tables"

Item Description

SQLCode

-858L

Constant

HISTOGRAMS_NOT_SUPPORTED_ON_OBJECT

SQLState

42W67

ODBC 2 State

37000

ODBC 3 State

42000

Sybase Error Code

2506

Severity Code

16

Probable cause

You attempted to use CREATE/DROP STATISTICS to create/drop one or more histograms on a virtual database object, such as a view or remote table. The CREATE STATISTICS and DROP STATISTICS statements can only refer to base tables, local temporary tables, or global temporary tables in the SQL Anywhere database that you are connected to.


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