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