Neoview Messages Manual (R2.2)

Table 22-3 SQLSTATE Values Beginning 01800 (continued)
Error TextSQLCODESQLSTATE
The operands of function name must be character data types.
40670181V
The operand of function name must contain an even number of characters.
40680181W
Column name uses an unsupported collation, name.
40690181X
The operand of function name must be exact numeric.
40700181Y
The first operand of function name must be a datetime.
40710181Z
The operand of function name must be a datetime containing a name.
407201820
The COLLATE clause might appear only after an expression of character data type,
not name.
407301821
CONTROL QUERY successful.407401822
Division by zero in constant expression name.
407501823
Overflow in constant expression name.
407601824
Function name accepts only one or two operands.
407701825
Function name does not accept a weight operand.
407801826
The operands of function name must be numeric.
407901827
Table name does not exist or is inaccessible.
40820182A
SQL object name is corrupt.
40840182C
File organization type of object name is not supported.
40850182D
Environment variable or define name does not exist.
40860182E
Prototype value 'name' is not a valid qualified name.
40870182F
The number of values in each TRANSPOSE item of a TRANSPOSE set must be equal.40880182G
Check constraint name contains a subquery, which is not yet supported.
40890182H
The number of output dynamic parameters (num) must equal the number of selected
values (num).
40930182L
The number of output host variables (num) must equal the number of selected values
(num).
40940182M
A DEFAULT whose value is NULL is not allowed in name.
40950182N
A DEFAULT specification is currently allowed only when simply contained in the
VALUES list of an INSERT.
40960182O
A NULL operand is not allowed in function name.
40970182P
A NULL operand is not allowed in operation name.
40980182Q
A NULL operand is not allowed in predicate name.
40990182R
A NULL value is not allowed in a select list unless it is CAST to some data type.41000182S
If name is intended to be a further table reference in the FROM clause, the preceding
join search condition must be enclosed in parentheses.
41010182T
The FIRST/ANY n syntax cannot be used with in an outermost SELECT statement.
41020182U
If a character literal was intended, you must use the single quote delimiter instead of
the double: name instead of name.
41040182W
Unknown translation.41050182X
The character set for the operand of function name must be name.
41060182Y
SQLSTATE Values 413