"INSERT ... ON EXISTING UPDATE not allowed: immediate materialized view %1 depends on %2"
| Item |
Description |
|
SQLCode
|
-1204L
|
|
Constant
|
UPDATE_ON_EXISTING_DEP_IMV
|
|
SQLState
|
55W33
|
|
ODBC 2 State
|
ERROR
|
|
ODBC 3 State
|
ERROR
|
|
Sybase Error Code
|
2881
|
|
Severity Code
|
16
|
|
Parameter 1
|
The name of dependent immediate materialized view.
|
|
Parameter 2
|
The name of the base table into which the insert was performed.
|
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.