Neoview Messages Manual (R2.3)

name
is an unaudited table.
Cause Materialized views that use unaudited tables are not supported.
Effect The creation of the materialized view fails.
Recovery Correct the syntax and resubmit.
SQL 12011
12011 The materialized view cannot be altered. ON STATEMENT and RECOMPUTE
materialized views do not contain an IGNORE CHANGES clause.
Cause The materialized view (MV) being altered is not an ON REQUEST MV to alter the
IGNORE CHANGES clause.
Effect The operation fails.
Recovery ON STATEMENT MVs and RECOMPUTE MVs do not have the IGNORE
CHANGES clause, so these materialized views cannot be altered.
SQL 12014
12014 The materialized view cannot be initialized; locking of name
failed.
name
is a table used by a materialized view being initialized.
Cause A table used by the materialized view cannot be locked, possibly because it is being
used by other applications.
Effect The materialized view cannot be initialized.
Recovery Resubmit the create statement. If the issue persists, contact the GMCSC.
SQL 12015
12015 Creation of an MVlog table for name failed.
name
is a table used by a materialized view.
Cause When a materialized view is created, log tables for its base tables are created as well.
The creation of such log tables failed.
Effect The creation of the materialized view fails.
Recovery Contact the GMCSC.
SQL 12016
12016 Unique indexes are not allowed on materialized views.
Cause An attempt was made to create a unique index on a materialized view.
Effect The operation fails.
Recovery None.
SQL 12020
12020 A duplicate of table name is present in the IGNORE CHANGES clause.
name
is a table.
Cause An attempt was made to submit a statement with an IGNORE CHANGES clause
which includes a table name more than once.
Effect The operation fails.
Recovery Resubmit with every table name in the IGNORE CHANGES clause used only
once.
230 Materialized Views Messages (12000 Through 12329)