Error 1192

"Cannot update multiple tables immediate materialized view %1 depends on"

Item Description

SQLCode

-1192L

Constant

CANNOT_UPDATE_TWO_TABLES_IMV

SQLState

55W29

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Sybase Error Code

2869

Severity Code

16

Parameter 1

The name of the view that depends on two or more tables in the update statement.

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.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com