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-51
Error Handling
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 re-executed 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
A 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
All the character data could not fit in the
target buffer, so the truncated result was
put in the buffer.
-8403 -8402 22001
The denominator value for division was
zero, so the statement failed.
-8408 -8419 22012
No indicator variable was specified for a
null value and the output value is null, so
the statement failed.
-8423 -8420 22002
An attempt was made to move a null
value into a field that requires valid
values, so the statement failed.
-8424 -8421,
-8425
23000,
X08BT
Table 4-13. Mapping SQL/MP SQLCODE to SQL/MX SQLCODE
Values (page3of4)
SQL/MP Error Description
SQL/MP
SQLCODE
SQL/MX
SQLCODE
SQL/MX
SQLSTATE