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

Table 3-3 SQLSTATE Values Beginning 01800 (continued)
Error TextSQLCODESQLSTATE
Column name has no default value, so DEFAULT cannot be specified.
41070182Z
Inside a ROWS SINCE, another sequence function contained an invalid reference to
the THIS function.
410801830
Sequence functions placed incorrectly: name.
410901831
The query contains sequence functions but no SEQUENCE BY clause: name.
411001832
The query contains a SEQUENCE BY clause but no sequence functions.411101833
Absolute and relative sampling cannot occur in the same BALANCE expression.411201834
The sample size for name Sampling must be num.
411301835
An absolute sample size must have a scale of zero.411401836
The sample size must be less than or equal to the sample period.411501837
The second operand of function name is invalid.
411601838
The cursor query expression might be nonupdateable.411701839
The cursor query expression is not updateable.41180183A
In a query with a GROUP BY, DISTINCT, or aggregate function, each column in the
ORDER BY clause must be one of the columns explicitly SELECTed by the query.
Column in error: name.
41200183C
In a query with a GROUP BY, DISTINCT, or aggregate function, each column in the
ORDER BY clause must be one of the columns explicitly SELECTed by the query.
Column in error: name. Table in scope: name.
41210183D
NULL cannot be assigned to NOT NULL column name.
41220183E
NULL cannot be cast to a NOT NULL data type.41230183F
More than one table will be locked: name.
41240183G
The select list of a subquery in a row value constructor, if the subquery is one of several
expressions rather than the only expression in the constructor, must be scalar (degree
of one).
41250183H
The row value constructors in a VALUES clause must be of equal degree.41260183I
Type type cannot be assigned to type type.
41270183J
Cannot retrieve default volume and subvolume information from =_DEFAULTS
define, DEFINEINFO error num.
41280183K
The operation (name) is not allowed. Try UNION ALL instead.
41340183Q
Primary key of table expression name must be used for join with embedded name
expression. Tables in scope: name.
415001846
Stream access supported only on updateable views name.
415101847
Table name cannot be both read and updated.
415201848
Statement might not compile due to an order requirement on stream expression.415301849
Statement might not compile due to an order requirement on embedded name
expression.
41540184A
Inner relation of left join cannot be stream expression. Tables in scope: name.
41570184D
Join of stream expressions not supported. Tables in scope: name.
41580184E
Intersection of stream expressions not supported. Tables in scope: name.
41590184F
110 SQLSTATE Values Returned by the Neoview Database