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 (A-C)

 

Cannot update multiple tables immediate materialized view %1 depends on

Error constant SQLE_CANNOT_UPDATE_TWO_TABLES_IMV
ODBC 2 State ERROR
ODBC 3 State ERROR
Parameter 1 The name of the view that depends on two or more tables in the update statement.
Severity 16
SQLCODE –1192
SQLSTATE 55W29
Sybase error code 13323
Probable cause

You attempted to simultaneously update two or more tables initialized immediate materialized view depends on. No more than one base table an immediate materialized view depends on can be updated in a statement.