SQL/MX 2.x Messages Manual (H06.10+, J06.03+)

SQL/MX MXCMP Messages (2000 through 2999)
HP NonStop SQL/MX Messages Manual—544518-011
4-25
Recovery. If applicable, resubmit the query with MINIMUM optimization level. Precede
the statement with:
CONTROL QUERY DEFAULT OPTIMIZATION-LEVEL 'MEDIUM';
Correct the CONTROL QUERY SHAPE specification and resubmit.
SQL 2104
Cause. NonStop SQL/MX was unable to compile this query, either because it was not
able to use the MEDIUM optimization level or because you used an incompatible
CONTROL QUERY SHAPE specification.
Effect. NonStop SQL/MX is unable to process this query.
Recovery. If applicable, use the MAXIMUM optimization level, correct the CONTROL
QUERY SHAPE specification, and resubmit.
SQL 2105
Cause. NonStop SQL/MX was unable to compile this query because you used an
incompatible CONTROL QUERY SHAPE specification.
Effect. NonStop SQL/MX is unable to process this query.
Recovery. Correct the CONTROL QUERY SHAPE specification and resubmit.
SQL 2106
Cause. NonStop SQL/MX was unable to compile this query because it is too long.
Effect. NonStop SQL/MX is unable to process this query.
Recovery. Try breaking the statement into smaller pieces.
2104 This query could not be compiled for one of two reasons:
a) incompatible Control Query Shape (CQS) specifications, or
b) 'MEDIUM' optimization level is not sufficient to satisfy
the CQS in effect. Suggestion: a) inspect the CQS in effect;
or b) raise the optimization level to 'MAXIMUM'. Note that
for this query, 'MAXIMUM' optimization level may result in a
long compile time.
2105 This query could not be compiled because of incompatible
Control Query Shape (CQS) specifications. Inspect the CQS in
effect.
2106 This statement could not be compiled since it is too
long. Break up large statements into smaller pieces.