SQL/MP to SQL/MX Database and Application Migration Guide

Converting SQL/MP Applications to SQL/MX
Applications
HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
4-50
Error Handling
An object’s definition changed since the
statement was last SQL compiled, so
automatic recompilation was attempted.
-8202 -8575 X08FZ
An OPEN operation on a table failed. -8204 -8574 01KFY,
X08FY
A DDL operation changed the AUDIT file
attribute of a table, causing automatic
recompilation to be attempted. If
automatic recompilation is not allowed,
the statement fails.
-8207 -8576 X08G0
A SQL program statement was
dynamically recompiled for the reason
stated in the error message.
-8208, -8209,
-8210
-8576 X08G0
A CLOSE CURSOR statement
attempted to close a cursor that was
already closed or was never opened, so
the cursor remains closed.
-8219 -8811 24000
An OPEN CURSOR statement
attempted to open a cursor that was
already open, so execution continues.
-8220 -8004 24000
A FETCH CURSOR statement was
issued for a cursor that was not open, so
the statement failed.
-8221 -8005 24000
More than one row in a table or tables
satisfied the query, but only one row is
allowed, so the statement failed
-8222 -8401 21000
The cursor specified in the statement
could not be located or used, so the
statement failed.
-8223 -8842 X08NE
An attempt was made to fetch from a
cursor that was not in the fetched state.
-8226 -8013 24000
The row being inserted or updated in a
table contains a key value that must be
unique, but the key value is already
present in a row. The insert or update
operation failed.
-8227 -8102 23000
An attempt was made to insert or update
a row that was not compatible with the
constraint, so the insert or update
operation failed.
-8228 -8101 23000
Table 4-13. Mapping SQL/MP SQLCODE to SQL/MX SQLCODE
Values (page2of4)
SQL/MP Error Description
SQL/MP
SQLCODE
SQL/MX
SQLCODE
SQL/MX
SQLSTATE