SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Release 3.2 Messages Manual691121-001
22-71
SQLSTATE Values
X044M -4166 ORDER BY clause not supported in UNION of two streams.
Tables in scope: name, name.
X044N -4167 Embedded name statements not supported in subqueries.
X044O -4168 Stream expressions not supported in subqueries.
X044P -4169 Embedded DELETE statements not allowed when using
DECLARE ... FOR UPDATE clause.
X044Q -4170 Stream expressions not supported for insert statements.
X044R -4171 Embedded name statements not supported in INSERT
statements.
X044T -4173 Stream expression not supported for top level UPDATE
statements.
X044U -4174 JOIN_ORDER_BY_USER prevented compiler from reordering
query tree.
X044V -4175 Join between embedded name expression and embedded
name expression not supported. Tables in scope: name.
X044W -4176 Join between stream expression and embedded name
expression not supported. Tables in scope: name.
X044X -4177 Update of name column name not permitted on rollback.
X044Y -4178 Update of variable length column name not permitted on
rollback.
X044Z -4179 SEQUENCE BY not supported for stream expressions.
X0450 -4180 Stream expression not supported for top level DELETE
statement.
X0451 -4181 Join with embedded name expression is not supported.
X0452 -4182 Selection predicate on any but the innermost correlation name
of an embedded name expression is not supported.
X045K -4200 Stream expressions not supported for compound statements.
X045L -4201 Embedded name expression not supported for compound
statements.
X045M -4202 SEQUENCE BY not supported for embedded name
expressions.
X045N -4203 INSERT/UPDATE/DELETE operation on nonaudited table
name requires index maintenance which might cause the
index(es) to become corrupt.
X045O -4204 Stream access only supported for key-sequenced tables.
Table: name.
X045P -4205 Embedded name only supported for key-sequenced tables.
Table: name.
Table 22-1. SQLSTATE Values (page 70 of 84)
SQLSTATE SQLCODE Error Text