"The materialized view cannot be changed to immediate because the ON conditions refer to tables which are not in the null-supplying and preserved sides of the OUTER JOINs."
Item |
Description |
SQLCode
|
-1507L
|
Constant
|
UPDATABLE_MATVIEW_OUTERREFERENCE_ON_CONDITION
|
SQLState
|
42WE7
|
ODBC 2 State
|
42000
|
ODBC 3 State
|
ERROR
|
Sybase Error Code
|
3175
|
Severity Code
|
15
|
Probable cause
You attempted to change the refresh type to immediate for a materialized view whose definition contains an illegal ON condition.