The materialized view %1 cannot be changed to immediate because it does not have a unique index on non-nullable columns

Error constant SQLE_IMMEDIATE_MV_NO_UNIQUE_INDEX
ODBC 2 State 42000
ODBC 3 State ERROR
Parameter 1 Name of the materialized view.
Severity 14
SQLCODE –1233
SQLSTATE 42WCA
Sybase error code 13284
Probable cause

You attempted to change the refresh type to immediate for a materialized view which does not have a unique index on non-nullable columns. Create a unique index on the materialized view before changing the refresh type.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0