In this blog post, you’ll learn more about the Sybase Error Cannot update materialized view because option ‘%1’ has an inappropriate setting and the reason for receiving this error
Sybase SQL Error Message
Cannot update materialized view because option ‘%1’ has an inappropriate setting
Reason for this Error
You attempted to update/refresh a materialized view but one of the database options is currently set to a value that is not permitted while updating a materialized view, or, the option’s setting does not match the value when the view was created.