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-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 20-1. SQLSTATE Values (page 58 of 85)
SQLSTATE SQLCODE Error Text