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-23
SQLSTATE Values
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 nonupdateable.
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.
01846 4150 Primary key of table expression name must be used for join
with embedded name expression. Tables in scope: name.
01847 4151 Stream access only supported on updateable views name.
01848 4152 Table name cannot be both read and updated.
01849 4153 Statement might not compile due to an order requirement on
stream expression.
0184A 4154 Statement might not compile due to an order requirement on
embedded name expression.
0184D 4157 Inner relation of left join cannot be stream expression. Tables
in scope: name.
0184E 4158 Join of stream expressions not supported. Tables in scope:
name.
Table 20-1. SQLSTATE Values (page 22 of 85)
SQLSTATE SQLCODE Error Text