Error constant | SQLE_UPDATABLE_MATVIEW_NON_AGGR_INDEX |
ODBC 2 State | 42000 |
ODBC 3 State | ERROR |
Severity | 16 |
SQLCODE | –1218 |
SQLSTATE | 42WC7 |
Sybase error code | 13299 |
You attempted to change the refresh type to immediate for a materialized view which does not have a unique index on non-aggregate non-nullable columns. Create a unique index on the materialized view before changing the refresh type.
Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |