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

Effect The creation of the table fails.
Recovery Correct the syntax and resubmit.
SQL 12033
12033 An underlying materialized view has an incompatible refresh type.
Cause You attempted to create a materialized view on top of another materialized view with
an incompatible refresh type.
Effect The creation of the materialized view fails.
Recovery The two materialized views must have compatible refresh types.
SQL 12038
12038 Cannot GRANT REFERENCES on materialized views.
Cause The REFERENCES privilege cannot be granted on a materialized view since a
materialized view cannot participate in a referential integrity relationship.
Effect The GRANT operations fails.
Recovery None.
SQL 12040
12040 An empty STORE BY clause is not supported for materialized views.
Cause If present, the STORE BY clause must include a non-empty list of columns.
Effect The creation of the materialized view fails.
Recovery Either add a list of columns to the STORE BY clause or remove the STORE BY
clause all together.
SQL 12042
12042 STORE BY PRIMARY KEY is not supported for materialized views
Cause A STORE BY PRIMARY KEY is not supported in a Create Materialized View statement.
Effect The creation of the materialized view fails.
Recovery Change the STORE BY clause and resubmit the Create Materialized View statement.
SQL 12046
12046 Fatal Error in attribute table lists - list type unknown.
Cause Some of the attributes specified in the CREATE Materialized View statement are not
allowed or unrecognized.
Effect The creation of the materialized view fails.
Recovery Analyze the list of attributes, remove or fix the wrong attributes and resubmit the
Create Materialized View statement.
SQL 12047
12047 ATTRIBUTE ALLOCATED not supported for materialized views.
Cause The ALLOCATED attribute is not supported for materialized views.
Effect The creation of the materialized view fails.
Recovery Remove the attribute from the materialized view definition.
SQL 12048
12048 ATTRIBUTE LOCK LENGTH not supported for materialized views.
Cause The LOCK LENGTH attribute is not supported for materialized views.
240 Materialized Views Messages (12000 Through 12329)