![HP NonStop SQL/MX Messages Manual Download Page 699](http://html.mh-extra.com/html/hp/nonstop-sql-mx/nonstop-sql-mx_messages-manual_165150699.webp)
SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual — 640324-001
21 -47
SQLSTATE Values
24000
-8013
Trying to update or delete from a cursor that is not in the
fetched state.
24000
-8811
Trying to close a statement that is either not in the open state
or has not reached EOF.
24000
-8812
Trying to execute a statement that is not in the closed state.
24000
-8813
Trying to fetch from a statement that is in the closed state.
24000
-8850
The table specified in this cursor update or DELETE statement
is different than the table specified in the declare cursor
statement.
25000
-1111
Error starting transaction.
table name.schema.name
25000
-1112
Error committing transaction.
table name.schema.name
25000
-3114
Transaction access mode READ WRITE is incompatible with
isolation level READ UNCOMMITTED.
25000
-3140
The isolation level cannot be READ UNCOMMITTED for an
INSERT, UPDATE, DELETE, or DDL statement.
25000
-3141
The transaction access mode cannot be READ ONLY for an
INSERT, UPDATE, DELETE, or DDL statement.
25000
-8603
Trying to begin a transaction that has already been started.
25000
-8604
Transaction subsystem
name
returned error
num
while starting
a transaction.
25000
-8605
Committing a transaction which has not started.
25000
-8606
Transaction subsystem
name
returned error
num
on a commit
transaction.
25000
-8612
Transaction mode cannot be set if the transaction is already
running.
25000
-8613
SQL cannot commit or rollback a transaction that was started
by application.
25000
-8614
SQL cannot be begin a transaction when multiple contexts
exist.
25000
-8814
The transaction mode at run time (
num
) differs from that
specified at compile time (
num
).
25000
-8819
Begin transaction failed while preparing the statement.
25000
-8820
Transaction commit failed while closing the statement.
25000
-8832
Transaction has not been started.
25000
-8833
The input parameter is an invalid SQL transaction command.
25000
-8841
User application committed or aborted a transaction started by
SQL. This transaction needs to be committed or aborted by
calling SQL COMMIT or ROLLBACK WORK.
Table 21-1. SQLSTATE Values (page 46 of 84)
SQLSTATE
SQLCODE
Error Text
Summary of Contents for NonStop SQL/MX
Page 4: ......
Page 8: ...Contents HP NonStop SQL MX Messages Manual 640324 001 iv ...
Page 26: ...General Messages 0 through 999 HP NonStop SQL MX Messages Manual 640324 001 2 2 ...
Page 130: ...SQL MX MXCMP Messages 2000 through 2999 HP NonStop SQL MX Messages Manual 640324 001 4 34 ...
Page 242: ...Normalizer Messages 5000 through 5999 HP NonStop SQL MX Messages Manual 640324 001 7 2 ...
Page 246: ...Optimizer Messages 6000 through 6999 HP NonStop SQL MX Messages Manual 640324 001 8 4 ...
Page 248: ...Generator Messages 7000 through 7999 HP NonStop SQL MX Messages Manual 640324 001 9 2 ...
Page 614: ...Utility Messages 20000 through 23099 HP NonStop SQL MX Messages Manual 640324 001 18 138 ...
Page 752: ...Non SQLCODE Error Messages HP NonStop SQL MX Messages Manual 640324 001 A 14 MXGNAMES Utility ...