HP NonStop SQL/MX, Messages Manual

Page: 672 / 752

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual — 640324-001
21 -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.
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
.
Table 21-1. SQLSTATE Values (page 19 of 84)
SQLSTATE SQLCODE Error Text