In this blog post, you’ll learn more about the Sybase Error Syntax error near ‘%1’ — The materialized view cannot be changed to immediate because its definition contains an illegal construct: ‘%2’ and the reason for receiving this error
Sybase SQL Error Message
Syntax error near ‘%1’ — The materialized view cannot be changed to immediate because its definition contains an illegal construct: ‘%2’
Reason for this Error
You attempted to change the refresh type to immediate for a materialized view whose definition violates one of the restrictions.