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

 

Immediate materialized view definition cannot contain a SUM function over a nullable expression

Error constant SQLE_UPDATABLE_MATVIEW_SUM_NULL_EXPR
ODBC 2 State ERROR
ODBC 3 State ERROR
Severity 15
SQLCODE –1286
SQLSTATE 42WCD
Sybase error code 13668
Probable cause

You attempted to change the refresh type to immediate for a materialized view whose definition contains a SUM function over a nullable expression.

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1