Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 12.0.1 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (T-Z)

 

The materialized view cannot be changed to immediate because its SELECT list contains a SUM function over a nullable expression and it doesn't contain a COUNT function over the same expression

Error constant SQLE_UPDATABLE_MATVIEW_COUNT_NULL_EXPR
ODBC 2 state ERROR
ODBC 3 state ERROR
Severity 15
SQLCODE -1327
SQLSTATE 42WCE
Sybase error code 13229
 Probable cause
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1