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

Table 3-7 SQLSTATE Values Beginning 42000 (continued)
Error TextSQLCODESQLSTATE
Not supported: SET STREAM TIMEOUT per a specific stream.-318742000
cannot set lock timeout on a view.-318942000
Column name is not found. Tables in scope: name. Default schema: name.
-400142000
Column name is not found. Table name not exposed. Tables in scope: name. Default
schema: name.
-400242000
Column name is not a column in table name, or, after a NATURAL JOIN or JOIN
USING, is no longer allowed to be specified with a table correlation name.
-400342000
Column name name is ambiguous. Tables in scope: name. Default schema: name.
-400442000
Column reference name must be a grouping column or be specified within an
aggregate.
-400542000
Within an aggregate, all column references must come from the same scope.-400642000
The select list index num is out of range. It must be between 1 and the number of select
expressions, which in this case is num.
-400742000
A subquery is not allowed inside an aggregate function.-400842000
An aggregate is not allowed inside an aggregate function.-400942000
There are no columns with the correlation name name.
-401042000
Ambiguous star column reference name.
-401142000
Column reference name must be a grouping column or be specified within an
aggregate. On this grouped table a star reference is not allowed.
-401242000
Column name is a system column and cannot be updated or inserted into.
-401342000
The operands of an INTERSECT must be of equal degree.-401442000
There are no columns with the correlation name name.
-401042000
Ambiguous star column reference name.
-401142000
Column reference name must be a grouping column or be specified within an
aggregate. On this grouped table a star reference is not allowed.
-401242000
Column name is a system column and cannot be updated or inserted into.
-401342000
The operands of an INTERSECT must be of equal degree.-401442000
Aggregate functions placed incorrectly: name.
-401542000
The number of derived columns (num) must equal the degree of the derived table
(num).
-401642000
Derived column name name was specified more than once.
-401742000
Rows cannot be deleted from an entry-sequenced table.-401842000
The select list of a subquery in a select list must be scalar (degree of one).-401942000
Arithmetic operations on row value constructors are not allowed.-402042000
The select list contains a nongrouping non-aggregated column, name.
-402142000
Target column name was specified more than once.
-402242000
The degree of each row value constructor (num) must equal the degree of the target
table column list (num).
-402342000
Column name has no default value, so must be explicitly specified in the insert column
list.
-402442000
136 SQLSTATE Values Returned by the Neoview Database