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

SQL 12319
12319 Too many changing base table tracked by the materialized view:
materialized view mv-name cannot be incrementally refreshed because num
of its base tables have changed.
mv-name
is a materialized view.
num
is the number of base tables used by the materialized view that have changed.
Cause The materialized view is tracking changes on too many changed base tables.
Effect The operation fails.
Recovery Refresh the materialized view with RECOMPUTE.
SQL 12320
12320 Creation failed. Materialized views on views are not supported.
The materialized view cannot be incrementally maintained.
Cause You attempted to create a materialized view on a view. This operation is not allowed.
Effect The operation fails because the materialized view cannot be maintained incrementally
.
Recovery Correct the syntax and resubmit.
SQL 12321
12321 Creation failed. The select list must have at least one column.
The materialized view cannot be maintained incrementally.
Cause You attempted to create a materialized view without columns in the select list. This
operation is not allowed.
Effect The operation fails because the materialized view cannot be incrementally maintained.
Recovery Correct the syntax and resubmit.
SQL 12322
12322 Creation failed. The same table is used more than once. The
materialized view cannot be maintained incrementally.
Cause You attempted to create a materialized view by using the same table more than once.
This operation is not allowed.
Effect The operation fails because the materialized view cannot be incrementally maintained.
Recovery Correct the syntax and resubmit.
SQL 12323
12323 Creation failed. The selection predicate includes a nonrepeatable
expression. The materialized view cannot be maintainedincrementally.
Cause You attempted to create a materialized view by using a selection predicate that includes
a nonrepeatable expression, such as CURRENT_TIME.
Effect The operation fails because the materialized view cannot be incrementally maintained.
Recovery Correct the syntax and resubmit.
SQL 12324
12324 Creation failed. The statement includes multiple GROUP BY clauses.
The materialized view cannot be maintained incrementally.
Cause You attempted to create a materialized view by using multiple group by clauses.
Effect The operation fails because the materialized view cannot be incrementally maintained.
249