In this blog post, you’ll learn more about the Sybase Error Immediate materialized view definition cannot contain a SUM function over a nullable expression. and the reason for receiving this error
Sybase SQL Error Message
Immediate materialized view definition cannot contain a SUM function over a nullable expression.
Reason for this Error
You attempted to change the refresh type to immediate for a materialized view whose definition contains a SUM function over a nullable expression.