SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
22-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 22-1. SQLSTATE Values (page 20 of 84)
SQLSTATE SQLCODE Error Text