HP Neoview Messages, Manual

Page: 259 / 400

Recovery
None.
SQL 12115
12115 The IGNORE CHANGES clause of materialized view mv-name cannot be
altered when the logs of the tables referred to in the IGNORE CHANGES
clause are not empty. Refresh the materialized view and try the ALTER
statement again.
mv-name
is a materialized view.
Cause An attempt was made to ALTER IGNORE CHANGES on a base table of the
materialized view and the insert/update/delete logs for the materialized view are not empty.
Effect
The operation fails.
Recovery
Refresh the materialized view, and then retry the ALTER MV statement.
SQL 12116
12116 The IGNORE CHANGES clause of materialized view mv-name cannot be
altered when the COMMIT REFRESH EACH mvattribute is specified and the
alter causes the materialized view to change from tracking changes on
one base table to multiple base tables.
mv-name
is a materialized view.
Cause An attempt was made to alter a materialized view such that the materialized view is
now tracking changes on more than one table. When the COMMIT REFRESH EACH attribute
is specified, the materialized view can only track changes on a single table.
Effect The operation fails.
Recovery Try altering the materialized view and remove the COMMIT REFRESH EACH
attribute and resubmit or only track changes on a single table.
SQL 12118
12118 Embedded Insert, Update or Delete is not allowed on a table used
by an ON STATEMENT Materialized View.
Cause
You attempted to execute an embedded insert, update, or delete operation on a table
that is the source of an ON STATEMENT materialized view.
Effect The query fails.
Recovery None, but if you need to complete the embedded insert, update, or delete operation,
you can drop the materialized view.
SQL 12119
12119 The Materialized View STORE BY clause includes non-base column
column-name.
column-name
refers to the column that should not be part of the clustering key.
Cause
You specified a STORE BY clause in the definition of an MJV (materialized join view)
and one of the columns in the clause is a derived column.
Effect The CREATE MATERIALIZED VIEW statement fails.
Recovery Neoview SQL recommends that you do not specify a STORE BY clause because
Neoview SQL will automatically cluster the materialized view.
SQL 12201
12201 MVGroup mv-group does not exist.
mv-group
is a materialized views group.
259