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

Effect The operation fails because the materialized view cannot be incrementally maintained.
Recovery Correct the syntax and resubmit.
SQL 12329
12329 Creation failed. Join predicates must have only one column instance
at each side of the equal sign. The materialized view cannot be
maintained incrementally.
Cause Your CREATE MV statement includes a join predicate with multiple column instances
on one side of the equal sign.
Effect The operation fails because the materialized view cannot be incrementally maintained.
Recovery Correct the syntax and resubmit.
SQL 12331
12331 Creation failed. Distinct aggregate functions are not supported.
The materialized view cannot be maintained incrementally.
Cause Distinct aggregate functions were used in an incremental materialized view.
Effect The materialized view is not created.
Recovery Change the materialized view query to avoid using DISTINCT, or change the
materialized view to RECOMPUTE.
SQL 12333
12333 Creation failed. INITIALIZE clause must be provided.
Cause There is a syntax error in the CREATE MV statement.
Effect The materialized view is not created.
Recovery Correct the CREATE MV syntax to include and INITIALIZE clause and resubmit.
SQL 12334
12334 Creation failed. Aggregate functions must be top level expressions.
The materialized view cannot be maintained incrementally.
Cause An expression involving an aggregate function that is not the top level expression
was used in an incremental materialized view.
Effect The materialized view is not created.
Recovery Change the materialized view so that aggregate functions are top level expressions.
265