Neoview Messages Manual (R2.2)

Table 22-7 SQLSTATE Values Beginning 42000 (continued)
Error TextSQLCODESQLSTATE
Precision of float, value, cannot exceed 54.
-313542000
Only LEFT, RIGHT, and FULL OUTER JOIN are valid in {oj ...}-313642000
A key-sequenced table with range partitioning requires a FIRST KEY clause.-313842000
A range-partitioned index requires a FIRST KEY clause.-313942000
INTO clause host variables are not allowed in a static cursor.-314242000
BROWSE or READ UNCOMMITTED access is not allowed on a table value constructor.-314342000
Positioned UPDATE or DELETE is allowed only in embedded SQL.-314542000
In an IN predicate whose right operand is a value list, the left operand must be scalar
(degree of one).
-314742000
Duplicate WITH CONSTRAINTS phrases in LIKE clause in CREATE TABLE statement.-314942000
Duplicate WITH HEADING phrases in LIKE clause in CREATE TABLE statement.-315042000
Duplicate WITH HORIZONTAL PARTITIONS phrases in LIKE clause in CREATE
TABLE statement.
-315142000
The FIRST KEY clause is not allowed with hash partitioning.-315342000
The POPULATE and NO POPULATE clauses cannot coexist in the same CREATE
INDEX statement.
-315542000
Catalog name is required.-315742000
If you intended name to be a character set specifier for a character string literal, you
must remove the spaces in front of the single quote delimiter.
-315942000
name was declared more than once in the procedure parameter list.
-316042000
name was not declared in the procedure parameter list.
-316142000
Data type mismatch between output host variable and selected value.-316442000
Min or max precision or exponent value exceeded, num.
-316542000
Min or max value for float or double value exceeded, num.
-316642000
Duplicate [ NOT ] DROPPABLE clauses.-316742000
The FOR ... ACCESS clause is not allowed in a CREATE VIEW statement.-316842000
Transaction statements are not allowed in compound statements.-317142000
EXIT is not allowed in a compound statement.-317242000
UPDATE STATISTICS is not allowed in a compound statement.-317342000
DDL statements are not allowed in compound statements.-317442000
Dynamic SQL statements are not allowed in compound statements.-317542000
Subqueries are not allowed in the IF Condition.-317642000
Character set name requires an even number of characters in the length declaration
of the data type.
-317742000
One or more of the following external (host-language) data types incorrectly appears
within the SQL query or operation: type.
-317842000
Collation name is not defined on the character set name.
-317942000
STREAM statements are not allowed in compound statements.-318042000
Invalid logical name, a three part logical name is required.-318142000
SQLSTATE Values 439