The materialized view cannot be changed to immediate because its definition must not contain more than one query block

Error constant	SQLE_UPDATABLE_MATVIEW_MULTIBLE_BLOCK_ERR
ODBC 2 State	42000
ODBC 3 State	ERROR
Severity	15
SQLCODE	–1181
SQLSTATE	42WC5
Sybase error code	13334

You attempted to change the refresh type to immediate for a materialized view whose definition contains more than one query block.

Discuss this page in DocCommentXchange.
Send feedback about this page using email.