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.

Discuss this page in DocCommentXchange.
Send feedback about this page using email.