![HP NonStop SQL/MX Messages Manual Download Page 703](http://html.mh-extra.com/html/hp/nonstop-sql-mx/nonstop-sql-mx_messages-manual_165150703.webp)
SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual — 640324-001
21 -51
SQLSTATE Values
42000
-2092
A module statement has already appeared in this file. The
previous definition,
name
, is being retained and this latest one
ignored.
42000
-2093
A module timestamp statement was not found in file
name
.
42000
-2094
A module timestamp statement has already appeared in this
module. The previous timestamp is being retained and this
latest one ignored.
42000
-2093
A module timestamp statement was not found in file
name
.
42000
-2094
A module timestamp statement has already appeared in this
module. The previous timestamp is being retained and this
latest one ignored.
42000
-2200
DEFAULTS attribute
name
is read-only.
42000
-30001
A rowset must be composed of host variable arrays.
42000
-30002
The given rowset size (
num
) must be smaller or equal to the
smallest dimension (
num
) of the arrays composing the rowset.
42000
-30003
Rowset size must be an integer host variable or constant.
42000
-30004
The dimension of the arrays composing the rowset must be
greater than zero. A value of
num
was given.
42000
-30005
The dimensions of the arrays composing the rowset are
different. The smallest dimension is assumed.
42000
-30006
Rowset and one-dimensional variable are in output list.
42000
-30007
Incompatible assignment from type
type
to type
type
42000
-3001
Syntax error at or before
SQL text
.
42000
-3002
name
is not a valid column reference; it has more than 4 name
parts.
42000
-3003
Length or precision must be greater than zero.
42000
-3004
A delimited identifier must contain at least one non-blank
character.
42000
-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.
42000
-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.
42000
-3007
In an ALLOCATE CURSOR statement both the cursor and the
statement must be named using string host variables.
42000
-3008
Precision of
name
UNSIGNED data type,
value
, cannot
exceed 9.
Table 21-1. SQLSTATE Values (page 50 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 ...