SQL/MX 2.x Messages Manual (H06.04+)

SQL/MX MXCMP Messages (2000 through 2999)
HP NonStop SQL/MX Messages Manual—540498-003
4-24
Recovery. If this is a warning, this is an informational message. Otherwise, correct the
syntax and resubmit.
SQL 2100
Cause. NonStop SQL/MX received a break and aborted the compilation.
Effect. NonStop SQL/MX does not continue compilation.
Recovery. Informational message only; no corrective action is needed.
SQL 2101
Cause. A compilation failed with an internal error.
Effect. NonStop SQL/MX is unable to process this query.
Recovery. None. Report the entire message to your service provider.
SQL 2102
Cause. NonStop SQL/MX was unable to compile this query using the MINIMUM
optimization level.
Effect. NonStop SQL/MX is unable to process this query.
Recovery. Resubmit the query with MEDIUM optimization level. Precede the
statement with:
CONTROL QUERY DEFAULT OPTIMIZATION-LEVEL 'MEDIUM';
SQL 2103
Cause. NonStop SQL/MX was unable to compile this query, either because it was not
able to use the MINIMUM optimization level or because you used an incompatible
CONTROL QUERY SHAPE specification.
Effect. NonStop SQL/MX is unable to process this query.
2100 Break was received. The compilation has been aborted.
2101 Compilation failure due to internal error.
2102 This query could not be compiled with 'MINIMUM'
optimization level. Suggestion: Retry with 'MEDIUM'
optimization level.
2103 This query could not be compiled for one/both of the
following reasons: a) Use of 'MINIMUM' optimization level, or
b) incompatible Control Query Shape specifications.