HP NonStop SQL/MX, Messages Manual

Page: 711 / 752

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual — 640324-001
21 -59
SQLSTATE Values
42000 -4042 The operands of a comparison predicate must be of equal
degree.
42000 -4043 The operand of function
name
must be character.
42000 -4044 Collation
name
does not support the
name
predicate or
function.
42000 -4045 The operand of function
name
must be numeric.
42000 -4046 The operands of function
name
must be exact numeric.
42000 -4047 The operands of function
name
must have a scale of 0.
42000 -4048 The third operand of a ternary comparison operator must be of
type BOOLEAN, not
name
.
42000 -4049 A CASE expression cannot have a result data type of both
type
and
type
.
42000 -4050 The operands of the
name
predicate must be comparable
character data types (that is, of the same character set and
collation).
42000 -4051 The first operand of function
name
must be character.
42000 -4052 The second operand of function
name
must be numeric.
42000 -4053 The third operand of function
name
must be numeric.
42000 -4055 The select lists or tuples must have comparable data types.
type
and
type
are not comparable.
42000 -4056 Exposed name
name
appears more than once.
42000 -4057 Correlation name
name
conflicts with qualified identifier of
table
name
.
42000 -4059 The first operand of function
name
must be numeric.
42000 -4061 Rows cannot be inserted into, or updated in, an individual
table partition.
42000 -4062 The preceding error actually occurred in function
name
.
42000 -4063 The operands of function
name
must be comparable character
data types (that is, of the same character set and collation).
42000 -4064 The operands of function
name
must be compatible character
data types (that is, of the same character set).
42000 -4066 The operands of a UNION must be of equal degree.
42000 -4067 The operands of function
name
must be character data types.
42000 -4068 The operand of function
name
must contain an even number
of characters.
42000 -4070 The operand of function
name
must be exact numeric.
42000 -4071 The first operand of function
name
must be a datetime.
Table 21-1. SQLSTATE Values (page 58 of 84)
SQLSTATE SQLCODE Error Text