SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

Converting SQL/MP Applications to SQL/MX
Applications
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
10-50
Error Handling
The statement was not prepared before
execution and failed.
-8031 -8822 X08MU
A specified cursor could not be located in
the program where it was declared, so
the statement failed.
-8116 -8836,
-8842
X08N8,
X08NE
An open operation on a table or view
failed because the table or view does not
exist or there was a security violation.
-8200 -8574 X08FY
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
An 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
Table 10-13. Mapping SQL/MP SQLCODE to SQL/MX SQLCODE
Values (page2of4)
SQL/MP Error Description
SQL/MP
SQLCODE
SQL/MX
SQLCODE
SQL/MX
SQLSTATE