"The materialized view cannot be changed to immediate because the primary key columns of any table in the preserved side of an OUTER JOIN must exist in the SELECT list."
Item |
Description |
SQLCode
|
-1509L
|
Constant
|
UPDATABLE_MATVIEW_PK
|
SQLState
|
42WE9
|
ODBC 2 State
|
42000
|
ODBC 3 State
|
ERROR
|
Sybase Error Code
|
3177
|
Severity Code
|
15
|
Probable cause
You attempted to change the refresh type to immediate for a materialized view whose SELECT list doesn't contain the primary key columns of any table in the preserved side of an OUTER JOIN.