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

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual—523730-004
20-70
SQLSTATE Values
X022U -2102 Unable to compile this query with 'MINIMUM' optimization
level. Suggestion: Retry with 'MEDIUM' optimization level.
X022V -2103 Unable to compile this query for one/both of the following
reasons: a) Use of 'MINIMUM' optimization level, or b)
Incompatible Control Query Shape specifications.
X022W -2104 Unable to compile this query 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 might result in a long compile
time.
X022X -2105 Unable to compile this query because of incompatible Control
Query Shape (CQS) specifications. Suggestion: Inspect the
CQS in effect.
X022Y -2106 Unable to compile this statement since it is too long.
Suggestion: Break up large statements into smaller pieces.
X022Z -2107 Unable to compile this statement. Suggestion: Address the
issue(s) raised in the reported warning(s).
X0230 -2108 Statement was compiled as if query plan caching were off.
X02P0 -2900 in file name at line num:
X0300 -3000 An internal error occurred in module name on line num.
DETAILS(text).
X0344 -3148 Environment variable name is being ignored because this
version of the code is Release, not Debug. Actual query
results will likely not match expected results.
X034I -3162 Procedure parameter name was not used.
X034J -3163 Host variable name appears more than once in the INTO list.
Execution results will be undefined.
X0352 -3182 Extra semicolon(;) in a compound statement.
X0400 -4000 Internal error in the query binder.
X0422 -4074 CONTROL QUERY successful.
X042B -4083 SQL/MP DDL operation failed.
X042U -4102 The FIRST/ANY n syntax cannot be used with in an
outermost SELECT statement.
X043G -4124 More than one table will be locked: name.
X0446 -4150 Primary key of table expression name must be used for join
with embedded name expression. Tables in scope: name.
X0447 -4151 Stream access only supported on updateable views name.
X0448 -4152 Table name cannot be both read and updated.
Table 20-1. SQLSTATE Values (page 69 of 85)
SQLSTATE SQLCODE Error Text