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

Effect The DML operation on the materialized view fails.
Recovery Contact the GMCSC.
SQL 12316
12316 No corresponding context row was found in the context log.
Cause This is an internal error used by the refresh utility to determine when the context log
is empty and the work is done.
Effect The operation fails.
Recovery None.
SQL 12318
12318 FIRST/ANY is not allowed in a query expression of a materialized
view.
Cause You specified FIRST or ANY in a query expression of a materialized view.
Effect The creation of the materialized view fails.
Recovery Correct the syntax and resubmit.
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.
263