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 (A-C)

 

CREATE/DROP STATISTICS statement cannot refer to virtual tables

Error constant SQLE_HISTOGRAMS_NOT_SUPPORTED_ON_OBJECT
ODBC 2 State 37000
ODBC 3 State 42000
Severity 16
SQLCODE –858
SQLSTATE 42W67
Sybase error code 13861
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.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0