SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual—523730-004
20-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 20-1. SQLSTATE Values (page 60 of 85)
SQLSTATE SQLCODE Error Text