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-20
SQLSTATE Values
0180V 4031 Column name is an unknown data type, num.
0180W 4032 Column name is an unknown class, num. It is neither a system
column nor a user column.
0180X 4033 Column name is a primary or clustering key column and
cannot be updated.
0180Y 4034 The operation (name name name) name is not allowed.
0180Z 4035 Type name cannot be cast to type type.
01810 4036 The source field of the EXTRACT function must be of
DateTime or Interval type.
01811 4037 Field name cannot be extracted from a source of type type.
01812 4038 The operand of an AVG or SUM function must be numeric or
interval.
01813 4039 Column name is of type type, incompatible with the value's
type, type.
01814 4040 The operands of a BETWEEN predicate must be of equal
degree.
01815 4041 Type name cannot be compared with type name.
01816 4042 The operands of a comparison predicate must be of equal
degree.
01817 4043 The operand of function name must be character.
01818 4044 Collation name does not support the name predicate or
function.
01819 4045 The operand of function name must be numeric.
0181A 4046 The operands of function name must be exact numeric.
0181B 4047 The operands of function name must have a scale of 0.
0181C 4048 The third operand of a ternary comparison operator must be of
type BOOLEAN, not name.
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.
Table 20-1. SQLSTATE Values (page 19 of 85)
SQLSTATE SQLCODE Error Text