HP NonStop SQL/MX, Messages Manual

Page: 673 / 752

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual — 640324-001
21 -21
SQLSTATE Values
0181D 4049 A CASE expression cannot have a result data type of both
type
and
type
.
0181E 4050 The operands of the
name
predicate must be comparable
character data types (that is, of the same character set and
collation).
0181F 4051 The first operand of function
name
must be character.
0181G 4052 The second operand of function
name
must be numeric.
0181H 4053 The third operand of function
name
must be numeric.
0181J 4055 The select lists or tuples must have comparable data types.
type
and
type
are not comparable.
0181K 4056 Exposed name
name
appears more than once.
0181L 4057 Correlation name
name
conflicts with qualified identifier of
table
name
.
0181N 4059 The first operand of function
name
must be numeric.
0181O 4060 Reading from and inserting into, or updating in, or deleting
from the same table,
name
, is not currently supported.
name
is
contained by view(s)
name
.
0181P 4061 Rows cannot be inserted into, or updated in, an individual
table partition.
0181Q 4062 The preceding error actually occurred in function
name
.
0181R 4063 The operands of function
name
must be comparable character
data types (that is, of the same character set and collation).
0181S 4064 The operands of function
name
must be compatible character
data types (that is, of the same character set).
0181U 4066 The operands of a UNION must be of equal degree.
0181V 4067 The operands of function
name
must be character data types.
0181W 4068 The operand of function
name
must contain an even number
of characters.
0181X 4069 Column
name
uses an unsupported collation,
name
.
0181Y 4070 The operand of function
name
must be exact numeric.
0181Z 4071 The first operand of function
name
must be a datetime.
01820 4072 The operand of function
name
must be a datetime containing a
name
.
01821 4073 The COLLATE clause might appear only after an expression of
character data type, not
name
.
01822 4074 CONTROL QUERY successful.
01823 4075 Division by zero in constant expression
name
.
01824 4076 Overflow in constant expression
name
.
Table 21-1. SQLSTATE Values (page 20 of 84)
SQLSTATE SQLCODE Error Text