Neoview Messages Manual (Volume 2) (R2.5)

Table 3-3 SQLSTATE Values Beginning 01800 (continued)
Error TextSQLCODESQLSTATE
Column name is an unknown class, num. It is neither a system column nor a user
column.
40320180W
Column name is a primary or clustering key column and cannot be updated.
40330180X
The operation (namenamename) name is not allowed.
40340180Y
Type name cannot be cast to type type.
40350180Z
The source field of the EXTRACT function must be of DateTime or Interval type.403601810
Field name cannot be extracted from a source of type type.
403701811
The operand of an AVG or SUM function must be numeric or interval.403801812
Column name is of type type, incompatible with the value's type, type.
403901813
The operands of a BETWEEN predicate must be of equal degree.404001814
Type name cannot be compared with type name.
404101815
The operands of a comparison predicate must be of equal degree.404201816
The operand of function name must be character.
404301817
Collation name does not support the name predicate or function.
404401818
The operand of function name must be numeric.
404501819
The operands of function name must be exact numeric.
40460181A
The operands of function name must have a scale of 0.
40470181B
The third operand of a ternary comparison operator must be of type BOOLEAN, not
name.
40480181C
A CASE expression cannot have a result data type of both type and type.
40490181D
The operands of the name predicate must be comparable character data types (that
is, of the same character set and collation).
40500181E
The first operand of function name must be character.
40510181F
The second operand of function name must be numeric.
40520181G
The third operand of function name must be numeric.
40530181H
The select lists or tuples must have comparable data types. type and type are not
comparable.
40550181J
Exposed name name appears more than once.
40560181K
Correlation name name conflicts with qualified identifier of table name.
40570181L
The first operand of function name must be numeric.
40590181N
Reading from and inserting into, or updating in, or deleting from the same table,
name, is not currently supported. name is contained by view(s) name.
40600181O
Rows cannot be inserted into, or updated in, an individual table partition.40610181P
The preceding error actually occurred in function name.
40620181Q
The operands of function name must be comparable character data types (that is, of
the same character set and collation).
40630181R
The operands of function name must be compatible character data types (that is, of
the same character set).
40640181S
The operands of a UNION must be of equal degree.40660181U
114 SQLSTATE Values Returned by the Neoview Database