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 (L-S)

 

Syntax error near '%1' -- The materialized view cannot be changed to immediate because its definition contains an illegal construct: '%2'

Error constant SQLE_UPDATABLE_MATVIEW_SYNTAX_ERROR
ODBC 2 State 42000
ODBC 3 State ERROR
Parameter 1 Location of the feature used that is not permitted.
Parameter 2 The feature used that is not permitted.
Severity 15
SQLCODE –1032
SQLSTATE 42WB4
Sybase error code 13480
Probable cause

You attempted to change the refresh type to immediate for a materialized view whose definition violates one of the restrictions.