HP Neoview Messages, Manual

Page: 255 / 400

SQL 12050
12050 ATTRIBUTE AUDIT not supported for materialized views.
Cause The AUDIT 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 12051
12051 ATTRIBUTE DEALLOCATE not supported for materialized views.
Cause
The DEALLOCATE 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 12066
12066 Embedded operation expression is not supported for materialized
views.
operation
is an INSERT operation.
Cause
You attempted to create a materialized view that contains an embedded INSERT
statement.
Effect The creation of the materialized view fails.
Recovery Remove the embedded INSERT from the materialized view definition.
SQL 12067
12067 Triggers and incremental materialized views may cause compilation
errors for updates on table table-name. Table record length of
actual-row-length is larger than the recommended length of max-row
length for tables with update triggers or incremental materialized
views.
table-name
is the name of the trigger or materialized view source table.
actual-row-length
is the row length of the MV source table or the trigger base table.
max-row-length
is the maximum row length of the MV source table or trigger base
table for which it is guaranteed that the compile error will not
occur.
Cause
Triggers and ON STATEMENT materialized views require the presence of an internal
table to help maintain them. The compilation of update DML statements that cause the firing
of UPDATE triggers or the refresh of ON STATEMENT materialized views might fail if the
table to be updated has a wide row. This informational message warns against the possibility
of this error occurring at compile time for the type of materialized view or trigger being created
on the given source table.
Effect None. This is an informational warning only.
Recovery None but you might reconsider creating the trigger or materialized view or if
possible redesigning the base or source table so that the row length is not as large.
SQL 12068
12068 This alter operation on table table-name may cause compilation
errors for updates on this table. UPDATE Triggers or incremental
materialized views exist on this table and the new record length of
actual-row-length is larger than the recommended length of
max-row-length.
255