![HP NonStop SQL/MX Messages Manual Download Page 664](http://html.mh-extra.com/html/hp/nonstop-sql-mx/nonstop-sql-mx_messages-manual_165150664.webp)
SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual — 640324-001
21 -12
SQLSTATE Values
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.
0170A
3010
Character set
name
is not yet supported.
0170B
3011
name
is not a valid qualified name; it has more than 3 name
parts.
0170C
3012
COUNT is the only aggregate function that accepts (*) as an
operand.
0170D
3013
Subtraction is the only operation allowed in the parenthesized
expression preceding an interval qualifier.
0170E
3014
Precision of numeric,
value
, cannot exceed 18.
0170F
3015
Scale
value
cannot exceed precision
value
.
0170G
3016
Precision of decimal,
value
, cannot exceed 18.
0170H
3017
Expected an unsigned integer, not
value
.
0170I
3018
Expected an unsigned smallint, not
value
.
0170J
3019
Expected an unsigned number within the parentheses, not
value
.
0170K
3020
Expected an unsigned number as the first operand within the
parentheses, not
value
.
0170L
3021
Expected an unsigned number as the second operand within
the parentheses, not
value
.
0170M
3022
The
name
operator is not yet supported.
0170N
3023
The COLLATE clause in a sort specification is not yet
supported.
0170O
3024
The MATCH PARTIAL clause is not yet supported.
0170P
3025
The format of the subvolume name part in the specified
location name
name
is invalid. The subvolume name part must
be eight characters long and begin with the letters ZSD.
0170Q
3026
A comma must be used to separate file attributes.
Table 21-1. SQLSTATE Values (page 11 of 84)
SQLSTATE
SQLCODE
Error Text
Summary of Contents for NonStop SQL/MX
Page 4: ......
Page 8: ...Contents HP NonStop SQL MX Messages Manual 640324 001 iv ...
Page 26: ...General Messages 0 through 999 HP NonStop SQL MX Messages Manual 640324 001 2 2 ...
Page 130: ...SQL MX MXCMP Messages 2000 through 2999 HP NonStop SQL MX Messages Manual 640324 001 4 34 ...
Page 242: ...Normalizer Messages 5000 through 5999 HP NonStop SQL MX Messages Manual 640324 001 7 2 ...
Page 246: ...Optimizer Messages 6000 through 6999 HP NonStop SQL MX Messages Manual 640324 001 8 4 ...
Page 248: ...Generator Messages 7000 through 7999 HP NonStop SQL MX Messages Manual 640324 001 9 2 ...
Page 614: ...Utility Messages 20000 through 23099 HP NonStop SQL MX Messages Manual 640324 001 18 138 ...
Page 752: ...Non SQLCODE Error Messages HP NonStop SQL MX Messages Manual 640324 001 A 14 MXGNAMES Utility ...