Neoview Messages Manual (R2.3)

Table 24-7 SQLSTATE Values Beginning 42000 (continued)
Error TextSQLCODESQLSTATE
The query contains sequence functions but no SEQUENCE BY clause: name.
-411042000
The query contains a SEQUENCE BY clause but no sequence functions.-411142000
Absolute and relative sampling cannot occur in the same BALANCE expression.-411242000
The sample size for name Sampling must be num.
-411342000
An absolute sample size must have a scale of zero.-411442000
The sample size must be less than or equal to the sample period.-411542000
The second operand of function name is invalid.
-411642000
The cursor query expression might be nonupdateable.-411742000
The cursor query expression is not updateable.-411842000
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.
-412042000
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.
-412142000
NULL cannot be assigned to NOT NULL column name.
-412242000
NULL cannot be cast to a NOT NULL data type.-412342000
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).
-412542000
The row value constructors in a VALUES clause must be of equal degree.-412642000
Type type cannot be assigned to type type.
-412742000
Cannot retrieve default volume and subvolume information from =_DEFAULTS
define, DEFINEINFO error num.
-412842000
The operation (name) is not allowed. Try UNION ALL instead.
-413442000
A plan using cluster sampling could not be produced for this query.-700342000
The user does not have name privilege on table or view name.
-857342000
Table 24-8 SQLSTATE Values Beginning 44000
Error TextSQLCODESQLSTATE
The operation is prevented by the check on view name cascaded from the check option
on table name.
-810444000
The operation is prevented by the check option on view name.
-810544000
Specified signature is invalid. Reason: The list of parameter types must be enclosed
in parentheses.
-1120846007
Specified signature is invalid. Reason: the number of parameters value must match
the number of parameters in Java method.
-1120946007
Specified signature is invalid. Reason: Missing [ ] for OUT/INOUT parameter at
position value.
-1121046007
Specified signature is invalid. Reason: Unknown parameter type used at position
value.
-1121146007
Specified signature is invalid. Reason: Java signature size is more than supported.-1121246007
SQLSTATE Values 461