Manualshelf

Neoview Messages Manual (Volume 1) (R2.4)

ManualsBrandsHP ManualsSoftwareHP Neoview Release 2.4 Software
241242243244245246247248249250
SQL 12114
12114 ON STATEMENT materialized views using this object.
Cause The table attribute was changed from audit to no audit.This is not allowed when an
ON STATEMENT materialized view is using it.
Effect The operation fails.
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 12201
12201 MVGroup mv-group does not exist.
mv-group
is a materialized views group.
Cause You used the name of an MVGroup that does not exist.
Effect The operation failed.
Recovery Correct the syntax and resubmit.
SQL 12202
12202 Materialized view mv-name does not exist.
Cause You specified a name of a materialized view that does not exist.
Effect The operation failed.
Recovery Correct the syntax and resubmit.
SQL 12203
12203 Materialized view mv-name already exists in MVGroup.
mv-name
is a materialized view.
245