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

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.
SQL 12327
12327 Creation failed. The select list contains a nongrouping,
nonaggregated column. The materialized view cannot be maintained
incrementally.
Cause You attempted to create a materialized view that includes a select list with a
nongrouping, nonaggregated column.
Effect The operation fails because the materialized view cannot be incrementally maintained.
Recovery Correct the syntax and resubmit.
SQL 12328
12328 Creation failed. Only equi-join predicates are allowed. The
materialized view cannot be maintained incrementally.
Cause You attempted to create a materialized view with a non equi-join predicate.
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.
250 Materialized Views Messages (12000 Through 12329)