iAnywhere.com - Cannot create materialized view because option '%1' has an inappropriate setting

Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

Cannot create materialized view because option '%1' has an inappropriate setting

Item	Value
Constant	SQLE_CANNOT_CREATE_MATVIEW
ODBC 2 State	42000
ODBC 3 State	ERROR
Parameter 1	Name of the option with the incorrect setting.
Severity	14
SQLCODE	-1051
SQLSTATE	42WB6
Sybase error code	13460

Probable cause

You attempted to create a materialized view, but one of the database options is currently set to a value not permitted while creating a materialized view.