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-11
SQLSTATE Values
0162V 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.
0162W 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.
0162X 2105 Unable to compile this query because of incompatible Control
Query Shape (CQS) specifications. Suggestion: Inspect the
CQS in effect.
0162Y 2106 Unable to compile this statement since it is too long.
Suggestion: Break up large statements into smaller pieces.
0162Z 2107 Unable to compile this statement. Suggestion: Address the
issue(s) raised in the reported warning(s).
01630 2108 Statement was compiled as if query plan caching were off.
0165K 2200 DEFAULTS attribute name is read-only.
016P0 2900 in file name at line num:
01700 3000 An internal error occurred in module name on line number.
DETAILS (detailed text).
01701 3001 Syntax error at or before SQL text.
01702 3002 name is not a valid column reference; it has more than 4 name
parts.
01703 3003 Length or precision must be greater than zero.
01704 3004 A delimited identifier must contain at least one non-blank
character.
01705 3005 A DECLARE CURSOR statement cannot dynamically get its
cursor name from a host variable while also statically declaring
a cursor specification. A dynamic cursor requires the name of
a previously prepared statement, or a host variable containing
such a name; a static cursor requires a fixed, static name.
01706 3006 In a dynamic cursor declaration both the cursor and the
statement must be named in the same way: both must be
literals or both must be string host variable expressions.
01707 3007 In an ALLOCATE CURSOR statement both the cursor and the
statement must be named using string host variables.
01708 3008 Precision of type UNSIGNED data type, value, cannot
exceed 9.
01709 3009 DROP ASSERTION statement is not yet supported.
Table 20-1. SQLSTATE Values (page 10 of 85)
SQLSTATE SQLCODE Error Text