SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

HP NonStop SQL/MX Messages Manual—523730-004
8-1
8
Optimizer Messages (6000 through
6999)
SQL 6000
Cause. The optimizer received an internal error during query optimization.
Effect. The operation fails.
Recovery. None. Contact your service provider.
SQL 6001
Cause. You attempted to compute DISTINCT aggregates for more than one column.
Effect. DISTINCT aggregates can be computed only for one column per table
expression.
Recovery. Correct syntax and resubmit.
SQL 6002
Cause. You have manually modified the metadata table, and now it contains invalid
values.
Effect. SQL/MX is unable to complete compilation.
Recovery. Undo your changes using the CLEAR option in UPDATE STATISTICS.
6000 Internal error in the query optimizer.
6001 DISTINCT aggregates can be computed for only one column
per table expression.
6002 The metadata table HISTOGRAMS or HISTOGRAM_INTERVALS
contains invalid values. If you have manually modified the
metadata table, then you should undo your changes using the
CLEAR option in UPDATE STATISTICS.