SQL/MP Messages Manual

SQL Compiler Optimizer Messages (6000 to 6999)
HP NonStop SQL/MP Messages Manual—427720-006
8-3
SQL 6008
Cause. Statistics on a table were not available during the compilation of a query.
Effect. The access path chosen by the SQL compiler might not be the most efficient.
Recovery. Issue the UPDATE STATISTICS command for all tables referred to by the
query, and reissue the query. For guidelines about the use of the UPDATE
STATISTICS command, refer to the SQL/MP Query Guide or the SQL/MP Reference
Manual.
SQL 6009
Cause. A file system error was returned to the SQL compiler while requesting label
information for the table. See the file system error following this error for the cause.
Effect. The statement does not compile.
Recovery. Correct the file system error condition. If you cannot correct the file system
error condition, report the entire message to your service provider.
SQL 6010
Cause. Internal error: An internal data structure of the SQL compiler was invalid.
Effect. The statement does not compile.
Recovery. None. Report the entire message to your service provider.
SQL 6011
Cause. More than one DISTINCT request was specified in a query or subquery.
Effect. The statement does not compile.
Recovery. Compose the query again so that there is at most one DISTINCT request
per query or subquery. Enter the new query.
6008 Statistics or partitions for a table were not available
so the access path chosen might not be the best available.
6009 The SQL compiler encountered a file system error while
trying to obtain the attributes of value-1.
6010 Internal error: The SQL compiler detected an
inconsistent internal data structure.
6011 Only one DISTINCT request is allowed per subquery.