"The materialized view cannot be changed to immediate because at least one non-nullable column from any null-supplying side of an OUTER JOIN must exist in the SELECT list."
| Item |
Description |
|
SQLCode
|
-1508L
|
|
Constant
|
UPDATABLE_MATVIEW_ISNOTNULL
|
|
SQLState
|
42WE8
|
|
ODBC 2 State
|
42000
|
|
ODBC 3 State
|
ERROR
|
|
Sybase Error Code
|
3176
|
|
Severity Code
|
15
|
Probable cause
You attempted to change the refresh type to immediate for a materialized view whose SELECT list doesn't contain at least one non-nullable column for any null-supplying side of an OUTER JOIN.