Neoview Messages Manual (R2.2)

Table 22-7 SQLSTATE Values Beginning 42000 (continued)
Error TextSQLCODESQLSTATE
The operands of function name must be comparable character data types (that is, of
the same character set and collation).
-406342000
The operands of function name must be compatible character data types (that is, of
the same character set).
-406442000
The operands of a UNION must be of equal degree.-406642000
The operands of function name must be character data types.
-406742000
The operand of function name must contain an even number of characters.
-406842000
The operand of function name must be exact numeric.
-407042000
The first operand of function name must be a datetime.
-407142000
The operand of function name must be a datetime containing a name.
-407242000
The COLLATE clause might appear only after an expression of character data type,
not type.
-407342000
Overflow in constant expression name.
-407642000
Function name accepts only one or two operands.
-407742000
Function name does not accept a weight operand.
-407842000
The operands of function name must be numeric.
-407942000
Table name does not exist or is inaccessible.
-408242000
SQL object tablename is corrupt.
-408442000
Environment variable or define name does not exist.
-408642000
Prototype value 'name' is not a valid qualified name.
-408742000
The number of values in each TRANSPOSE item of a TRANSPOSE set must be equal.-408842000
The number of output dynamic parameters (num) must equal the number of selected
values (num).
-409342000
The number of output host variables (num) must equal the number of selected values
(num).
-409442000
A DEFAULT whose value is NULL is not allowed in name.
-409542000
A NULL operand is not allowed in function name.
-409742000
A NULL operand is not allowed in operation name.
-409842000
A NULL operand is not allowed in predicate name.
-409942000
A NULL value is not allowed in a select list unless it is CAST to some data type.-410042000
If name is intended to be a further table reference in the FROM clause, the preceding
join search condition must be enclosed in parentheses.
-410142000
If a character literal was intended, you must use the single quote delimiter instead of
the double: name instead of name.
-410442000
Unknown translation.-410542000
The character set for the operand of function name must be name.
-410642000
Column name has no default value, so DEFAULT cannot be specified.
-410742000
Inside a ROWS SINCE, another sequence function contained an invalid reference to
the THIS function.
-410842000
Sequence functions placed incorrectly: name.
-410942000
442 SQLSTATE Values Returned by the Neoview Database