HP NonStop SQL/MX, Messages Manual

Page: 710 / 752

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