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-20
SQLSTATE Values
0180N 4023 The degree of each row value constructor (num) must equal
the degree of the target table column list (num).
0180O 4024 Column name has no default value, so must be explicitly
specified in the insert column list.
0180P 4025 Error while preparing constraint name on table name.
0180Q 4026 Reading from and inserting into, or updating in, or deleting
from the same table, name, is not currently supported.
0180R 4027 Table name is not insertable.
0180S 4028 Table name is not updateable.
0180U 4030 Column name is an invalid combination of datetime fields
(num, num, num).
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.
01
81A 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.
Table 22-1. SQLSTATE Values (page 19 of 84)
SQLSTATE SQLCODE Error Text