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

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual523730-004
20-25
SQLSTATE Values
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.
0185Z 4215 Stream access is not allowed on a nonaudited table. Table:
name.
01860 4216 The FIRST/ANY n syntax cannot be used with an embedded
update or embedded DELETE statement.
01861 4217 text
0188C 4300 Invalid usage of procedure procedure-name - A UDR was
invoked within a trigger.
0188E 4302 Procedure procedure-name expects value1 parameters
but was called with value2 parameters.
0188F 4303 The supplied type for parameter value of routine routine-
name was type-name1 which is not compatible with the
expected type type-name2.
Table 20-1. SQLSTATE Values (page 24 of 85)
SQLSTATE SQLCODE Error Text