The materialized view cannot be changed to immediate because COUNT(*) is required to be part of the SELECT list

Error constant	SQLE_UPDATABLE_MATVIEW_MISSING_COUNT
ODBC 2 State	42000
ODBC 3 State	ERROR
Severity	15
SQLCODE	–1199
SQLSTATE	42WC6
Sybase error code	13316

You attempted to change the refresh type to immediate for a materialized view whose definition does not include COUNT(*) in the SELECT list.

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