Neoview Messages Manual (R2.3)

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.
Recovery Correct the syntax and resubmit.
SQL 12325
12325 Creation failed. The statement includes a HAVING clause. The
materialized view cannot be maintained incrementally.
Cause Your CREATE MV statement includes the HAVING clause.
Effect The operation fails because the materialized view cannot be incrementally maintained.
Recovery Correct the syntax and resubmit.
SQL 12326
12326 Creation failed. Cross joins without equal join predicates are
not supported. The materialized view cannot be maintained incrementally.
Cause Your CREATE MV statement includes cross joins without equi-join predicates.
Effect The operation fails because the materialized view cannot be incrementally maintained.
Recovery Correct the syntax and resubmit.
240 Materialized Views Messages (12000 Through 12329)