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-51
Error Handling
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
The cursor specified in an UPDATE
WHERE CURRENT OF request did not
have the required update column list, so
the update operation failed.
-8229 -8836 X08N8
The data to be inserted or updated
resulted in a row that violated a
constraint on the table, so the insert or
update operation failed.
-8233 -8101 23000
The SQL/MP executor received an error
and reexecuted the statement using a
different access strategy,
-8237 -8576 X08G0
A partition of a file was not available at
run time, and the user used a CONTROL
TABLE statement to request that
SQL/MP skip the partition.
-8239
(similar to
late-name
resolution
error but not
the same)
-8302
(late-name
resolution
error)
X088E
A DEFINE referred to by a statement that
uses execution-time name resolution
was missing or not usable, so the
statement failed.
-8270 -8100 X082S
The file system detected a problem
within the specified file, so the statement
failed.
-8300 -8551 X08FB
An SQL statement failed because a TMF
transaction was not in progress.
-8312 -8605 25000
An overflow occurred during arithmetic
operation or during an INSERT or
UPDATE operation on a numeric column,
so the statement failed.
-8402 -8411 22003
Table 10-13. Mapping SQL/MP SQLCODE to SQL/MX SQLCODE
Values (page3of4)
SQL/MP Error Description
SQL/MP
SQLCODE
SQL/MX
SQLCODE
SQL/MX
SQLSTATE