Neoview Messages Manual (R2.2)

Table 22-7 SQLSTATE Values Beginning 42000 (continued)
Error TextSQLCODESQLSTATE
Error while preparing constraint name on table name.
-402542000
Table name is not insertable.
-402742000
Table name is not updateable.
-402842000
Column name is an invalid combination of datetime fields (num, num, num).
-403042000
Column name is an unknown data type, num.
-403142000
Column name is an unknown class, num. It is neither a system column nor a user
column.
-403242000
Column name is a primary or clustering key column and cannot be updated.
-403342000
The operation (namenamename) name is not allowed.
-403442000
Type type cannot be cast to type type.
-403542000
The source field of the EXTRACT function must be of DateTime or Interval type.-403642000
Field name cannot be extracted from a source of type type.
-403742000
The operand of an AVG or SUM function must be numeric or interval.-403842000
Column name is of type type, incompatible with the value's type, type.
-403942000
The operands of a BETWEEN predicate must be of equal degree.-404042000
Type type cannot be compared with type type.
-404142000
The operands of a comparison predicate must be of equal degree.-404242000
The operand of function name must be character.
-404342000
Collation name does not support the name predicate or function.
-404442000
The operand of function name must be numeric.
-404542000
The operands of function name must be exact numeric.
-404642000
The operands of function name must have a scale of 0.
-404742000
The third operand of a ternary comparison operator must be of type BOOLEAN, not
name.
-404842000
A CASE expression cannot have a result data type of both type and type.
-404942000
The operands of the name predicate must be comparable character data types (that
is, of the same character set and collation).
-405042000
The first operand of function name must be character.
-405142000
The second operand of function name must be numeric.
-405242000
The third operand of function name must be numeric.
-405342000
The select lists or tuples must have comparable data types. type and type are not
comparable.
-405542000
Exposed name name appears more than once.
-405642000
Correlation name name conflicts with qualified identifier of table name.
-405742000
The first operand of function name must be numeric.
-405942000
Rows cannot be inserted into, or updated in, an individual table partition.-406142000
The preceding error actually occurred in function name.
-406242000
SQLSTATE Values 441