HP NonStop SQL/MX, Messages Manual

Page: 713 / 752

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual — 640324-001
21 -61
SQLSTATE Values
42000 -4109 Sequence functions placed incorrectly:
name
.
42000 -4110 The query contains sequence functions but no SEQUENCE
BY clause:
name
.
42000 -4111 The query contains a SEQUENCE BY clause but no sequence
functions.
42000 -4112 Absolute and relative sampling cannot occur in the same
BALANCE expression.
42000 -4113 The sample size for
name
Sampling must be
num
.
42000 -4114 An absolute sample size must have a scale of zero.
42000 -4115 The sample size must be less than or equal to the sample
period.
42000 -4116 The second operand of function
name
is invalid.
42000 -4117 The cursor query expression might be nonupdatable.
42000 -4118 The cursor query expression is not updateable.
42000 -4120 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
.
42000 -4121 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
.
42000 -4122 NULL cannot be assigned to NOT NULL column
name
.
42000 -4123 NULL cannot be cast to a NOT NULL data type.
42000 -4125 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).
42000 -4126 The row value constructors in a VALUES clause must be of
equal degree.
42000 -4127 Type
type
cannot be assigned to type
type
.
42000 -4128 Cannot retrieve default volume and subvolume information
from =_DEFAULTS define, DEFINEINFO error
num
.
42000 -4134 The operation (
name
) is not allowed. Try UNION ALL instead.
42000 -7003 A plan using cluster sampling could not be produced for this
query.
42000 -8573 The user does not have
name
privilege on table or view
name
.
44000 -8104 The operation is prevented by the check on view
name
cascaded from the check option on
table name
.
44000 -8105 The operation is prevented by the check option on view
name
.
Table 21-1. SQLSTATE Values (page 60 of 84)
SQLSTATE SQLCODE Error Text