HPE NonStop SQL/MX Error – 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.

In this blog post, let’s learn about the error message “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.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

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.

Reason for the Error

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.

Solution

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