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 Manual—691121-001
22-25
SQLSTATE Values
0184U 4174 JOIN_ORDER_BY_USER prevented compiler from reordering
query tree.
0184V 4175 Join between embedded name expression and embedded
name expression not supported. Tables in scope: name.
0184W 4176 Join between stream expression and embedded name
expression not supported. Tables in scope: name.
0184X 4177 Update of name column name not permitted on rollback.
0184Y 4178 Update of variable length column name not permitted on
rollback.
0184Z 4179 SEQUENCE BY not supported for stream expressions.
01850 4180 Stream expression not supported for top level DELETE
statement.
0185K 4200 Stream expressions not supported for compound statements.
0185L 4201 Embedded type expression not supported for compound
statements.
0185M 4202 SEQUENCE BY not supported for embedded type
expressions.
0185N 4203 INSERT/UPDATE/DELETE operation on nonaudited table
name requires index maintenance which might cause the
index(es) to become corrupt.
0185O 4204 Stream access only supported for key-sequenced tables.
Table: name.
0185P 4205 Embedded type only supported for key-sequenced tables.
Table: name.
0185Q 4206 Embedded type only supported for updateable views. View:
name.
0185R 4207 Index name and other indexes covering a subset of columns
do not cover all output values of stream.
0185S 4208 Index name and other indexes covering a subset of columns
do not cover all columns referenced in where clause of
stream.
0185T 4209 Update of nullable column name not permitted on rollback.
0185U 4210 Embedded UPDATE/DELETE statements are not supported
within an IF statement.
0185W 4212 table name cannot be used to satisfy order requirement on
the stream because it is partitioned.
0185X 4213 Use of rowsets in a predicate with embedded
UPDATE/DELETE not supported.
0185Y 4214 The SET ON ROLLBACK clause is not allowed on a
non-audited table. Table: name.
Table 22-1. SQLSTATE Values (page 24 of 84)
SQLSTATE SQLCODE Error Text