In this blog post, you’ll learn more about the Sybase Error INSERT…ON EXISTING UPDATE not allowed: immediate materialized view %1 depends on %2 and the reason for receiving this error
Sybase SQL Error Message
INSERT…ON EXISTING UPDATE not allowed: immediate materialized view %1 depends on %2
Reason for this Error
Insert statement with ON EXISTING clause is not permitted on a base table if the base table has dependent initialized immediate materialized view.