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

Table 3-3 SQLSTATE Values Beginning 01800
Error TextSQLCODESQLSTATE
Internal error in the query binder.400001800
Column name is not found. Tables in scope: name. Default schema: name.
400101801
Column name is not found. Table name not exposed. Tables in scope: name. Default
schema: name.
400201802
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.
400301803
Column name name is ambiguous. Tables in scope: name. Default schema: name.
400401804
Column reference name must be a grouping column or be specified within an
aggregate.
400501805
Within an aggregate, all column references must come from the same scope.400601806
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.
400701807
A subquery is not allowed inside an aggregate function.400801808
An aggregate is not allowed inside an aggregate function.400901809
There are no columns with the correlation name name.
40100180A
Ambiguous star column reference name.
40110180B
Column reference name must be a grouping column or be specified within an
aggregate. On this grouped table a star reference is not allowed.
40120180C
Column name is a system column and cannot be updated or inserted into.
40130180D
The operands of an INTERSECT must be of equal degree.40140180E
Aggregate functions placed incorrectly: name.
40150180F
The number of derived columns (num) must equal the degree of the derived table
(num).
40160180G
Derived column name name was specified more than once.
40170180H
Rows cannot be deleted from an entry-sequenced table.40180180I
The select list of a subquery in a select list must be scalar (degree of one).40190180J
Arithmetic operations on row value constructors are not allowed.40200180K
The select list contains a nongrouping non-aggregated column, name.
40210180L
Target column name was specified more than once.
40220180M
The degree of each row value constructor (num) must equal the degree of the target
table column list (num).
40230180N
Column name has no default value, so must be explicitly specified in the insert column
list.
40240180O
Error while preparing constraint name on table name.
40250180P
Reading from and inserting into, or updating in, or deleting from the same table,
name, is not currently supported.
40260180Q
Table name is not insertable.
40270180R
Table name is not updateable.
40280180S
Column name is an invalid combination of datetime fields (num, num, num).
40300180U
Column name is an unknown data type, num.
40310180V
SQLSTATE Values 107