Neoview Messages Manual (R2.3)

SQL 12092
12092 Group by columns cannot exceed 255 characters.
Cause The total size of all the materialized view Group By columns exceeds 255 characters.
Effect The creation of the materialized view fails.
Recovery Rewrite the Create Materialized View statement so that the total size of all the
Group BY columns does not exceed 255 characters, and resubmit the Create Materialized View
statement.
SQL 12106
12106 The index was created with NO POPULATE clause. It will be populated
during first refresh.
Cause A newly created index will not be populated until the materialized view is initialized.
Effect The is an informational message. The index cannot be used until the materialized
view is refreshed.
Recovery None.
SQL 12107
12107 The STORE BY clause is illegal. The specified columns are
aggregated columns or do not exist.
Cause The materialized view STORE BY clause includes references to the materialized view
columns that are either aggregate or nonexistent columns.
Effect The creation of the materialized view fails.
Recovery Fix the STORE BY clause to exclude the aggregate or nonexistent columns and
resubmit statement.
SQL 12108
12108 The materialized view was defined without a STORE BY clause.
Cause The materialized view definition does not include a STORE BY clause and all the
GROUP BY columns are nullable columns.
Effect The creation of the materialized view fails.
Recovery Add one or more non-null columns as group by columns and resubmit the create
materialized view statement.
SQL 12109
12109 To ensure optimal Refresh performance, the STORE BY clause should
include the following GROUP BY columns: col-names.
col-names
are the group by columns that should be included in the STORE BY clause.
Cause To improve the materialized view refresh performance, the specified columns should
have been included in the STORE BY clause.
Effect This is an informational message. The materialized view is created successfully.
Recovery None, but you can drop and recreate the materialized view with the recommended
STORE BY clause to improve refresh performance.
SQL 12110
12110 The materialized view mv-name and its dependents were dropped
because of insufficient privileges.
mv-name
is the name of the dropped materialized view.
234 Materialized Views Messages (12000 Through 12329)