SAP Knowledge Base Article - Preview

2190916 - Errors when running CREATE STATISTICS and DROP STATISTICS in SAP IQ


When running CREATE STATISTICS or DROP STATISTICS you receive errors similar to the following:

Could not execute statement.
Server '': engine\omni\.\qdgentree.c:4493
Query Decomposition:  Unknown
Stmt Type
SQLCODE=-660, ODBC 3 State="HY000"
Line 4, column 1
Could not execute statement.
CREATE/DROP STATISTICS statement cannot refer to virtual tables
SQLCODE=-858, ODBC 3 State="42000"
Line 6, column 1



  • SAP IQ 16.0
  • SAP IQ 15.4
  • SAP Sybase IQ 15.3


SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4


KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.