HP NonStop SQL/MX, Messages Manual

Page: 675 / 752

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual — 640324-001
21 -23
SQLSTATE Values
0182Z 4107 Column
name
has no default value, so DEFAULT cannot be
specified.
01830 4108 Inside a ROWS SINCE, another sequence function contained
an invalid reference to the THIS function.
01831 4109 Sequence functions placed incorrectly:
name
.
01832 4110 The query contains sequence functions but no SEQUENCE
BY clause:
name
.
01833 4111 The query contains a SEQUENCE BY clause but no sequence
functions.
01834 4112 Absolute and relative sampling cannot occur in the same
BALANCE expression.
01835 4113 The sample size for
name
Sampling must be
num
.
01836 4114 An absolute sample size must have a scale of zero.
01837 4115 The sample size must be less than or equal to the sample
period.
01838 4116 The second operand of function
name
is invalid.
01839 4117 The cursor query expression might be nonupdatable.
0183A 4118 The cursor query expression is not updateable.
0183C 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
.
0183D 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
.
0183E 4122 NULL cannot be assigned to NOT NULL column
name
.
0183F 4123 NULL cannot be cast to a NOT NULL data type.
0183G 4124 More than one table will be locked:
name
.
0183H 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).
0183I 4126 The row value constructors in a VALUES clause must be of
equal degree.
0183J 4127 Type
type
cannot be assigned to type
type
.
0183K 4128 Cannot retrieve default volume and subvolume information
from =_DEFAULTS define, DEFINEINFO error
num
.
0183Q 4134 The operation (
name
) is not allowed. Try UNION ALL instead.
Table 21-1. SQLSTATE Values (page 22 of 84)
SQLSTATE SQLCODE Error Text