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 (D-K)

 

INSERT ... ON EXISTING UPDATE not allowed: immediate materialized view %1 depends on %2

Error constant SQLE_UPDATE_ON_EXISTING_DEP_IMV
ODBC 2 State ERROR
ODBC 3 State ERROR
Parameter 1 The name of dependent immediate materialized view.
Parameter 2 The name of the base table into which the insert was performed.
Severity 16
SQLCODE –1204
SQLSTATE 55W33
Sybase error code 13311
Probable cause

Insert statement with ON EXISTING clause is not permitted on a base table if the base table has dependent initialized immediate materialized view.