SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual — 640324-001
21 -60
SQLSTATE Values
42000
-4072
The operand of function
name
must be a datetime containing a
name
.
42000
-4073
The COLLATE clause might appear only after an expression of
character data type, not
type
.
42000
-4076
Overflow in constant expression
name
.
42000
-4077
Function
name
accepts only one or two operands.
42000
-4078
Function
name
does not accept a weight operand.
42000
-4079
The operands of function
name
must be numeric.
42000
-4080
SQL/MP error:
num
num
.
42000
-4081
SQL/MP error:
num
42000
-4082
Table
name
does not exist or is inaccessible.
42000
-4084
SQL object
table
name
is corrupt.
42000
-4086
Environment variable or define
name
does not exist.
42000
-4087
Prototype value '
name
' is not a valid qualified name.
42000
-4088
The number of values in each TRANSPOSE item of a
TRANSPOSE set must be equal.
42000
-4093
The number of output dynamic parameters (
num
) must equal
the number of selected values (
num
).
42000
-4094
The number of output host variables (
num
) must equal the
number of selected values (
num
).
42000
-4095
A DEFAULT whose value is NULL is not allowed in
name
.
42000
-4097
A NULL operand is not allowed in function
name
.
42000
-4098
A NULL operand is not allowed in operation
name
.
42000
-4099
A NULL operand is not allowed in predicate
name
.
42000
-4100
A NULL value is not allowed in a select list unless it is CAST
to some data type.
42000
-4101
If
name
is intended to be a further table reference in the FROM
clause, the preceding join search condition must be enclosed
in parentheses.
42000
-4104
If a character literal was intended, you must use the single
quote delimiter instead of the double:
name
instead of
name
.
42000
-4105
Unknown translation.
42000
-4106
The character set for the operand of function
name
must be
name
.
42000
-4107
Column
name
has no default value, so DEFAULT cannot be
specified.
42000
-4108
Inside a ROWS SINCE, another sequence function contained
an invalid reference to the THIS function.
Table 21-1. SQLSTATE Values (page 59 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 ...