In this blog post, you’ll learn more about the Sybase Error The materialized view cannot be changed to immediate because its definition contains an illegal construct. and the reason for receiving this error
Sybase SQL Error Message
The materialized view cannot be changed to immediate because its definition contains an illegal construct.
Reason for this Error
You attempted to change the refresh type to immediate for a materialized view whose definition contains an illegal construct.