Error 1286

"Immediate materialized view definition cannot contain a SUM function over a nullable expression."

Item Description

SQLCode

-1286L

Constant

UPDATABLE_MATVIEW_SUM_NULL_EXPR

SQLState

42WCD

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Sybase Error Code

2974

Severity Code

15

Probable cause

You attempted to change the refresh type to immediate for a materialized view whose definition contains a SUM function over a nullable expression.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com