HP NonStop SQL/MX - Page 710

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual—640324-001
21-58
SQLSTATE Values
42000 -4016 The number of derived columns (num) must equal the degree
of the derived table (num).
42000 -4017 Derived column name name was specified more than once.
42000 -4018 Rows cannot be deleted from an entry-sequenced table.
42000 -4019 The select list of a subquery in a select list must be scalar
(degree of one).
42000 -4020 Arithmetic operations on row value constructors are not
allowed.
42000 -4021 The select list contains a nongrouping non-aggregated
column, name.
42000 -4022 Target column name was specified more than once.
42000 -4023 The degree of each row value constructor (num) must equal
the degree of the target table column list (num).
42000 -4024 Column name has no default value, so must be explicitly
specified in the insert column list.
42000 -4025 Error while preparing constraint name on table name.
42000 -4027 Table name is not insertable.
42000 -4028 Table name is not updateable.
42000 -4030 Column name is an invalid combination of datetime fields
(num, num, num).
42000 -4031 Column name is an unknown data type, num.
42000 -4032 Column name is an unknown class, num. It is neither a system
column nor a user column.
42000 -4033 Column name is a primary or clustering key column and
cannot be updated.
42000 -4034 The operation (name name name) name is not allowed.
42000 -4035 Type type cannot be cast to type type.
42000 -4036 The source field of the EXTRACT function must be of
DateTime or Interval type.
42000 -4037 Field name cannot be extracted from a source of type type.
42000 -4038 The operand of an AVG or SUM function must be numeric or
interval.
42000 -4039 Column name is of type type, incompatible with the value's
type, type.
42000 -4040 The operands of a BETWEEN predicate must be of equal
degree.
42000 -4041 Type type
cannot be compared with type type.
Table 21-1. SQLSTATE Values (page 57 of 84)
SQLSTATE SQLCODE Error Text