Neoview Messages Manual (R2.2)

SQL 12318
12318 FIRST/ANY is not allowed in 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 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 incrementally maintained.
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 incrementally maintained.
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 incrementally maintained.
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 incrementally maintained.
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 incrementally maintained.
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.
Recovery Correct the syntax and resubmit.
228 Materialized Views Messages (12000 Through 12329)