SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)
SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
22-73
SQLSTATE Values
X0600 -6000 Internal error in the query optimizer.
X0602 -6002 The metadata table HISTOGRAMS or
HISTOGRAM_INTERVALS contains invalid values. If you
have manually modified the metadata table, then you should
undo your changes using the CLEAR option in UPDATE
STATISTICS.
X0607 -6007 Multi-column statistics for columns name from table name were
not available; as a result, the access path chosen might not be
the best possible.
X0608 -6008 Statistics for column name were not available; as a result, the
access path chosen might not be the best possible.
X0700 -7000 Internal error in the code generator in file name at line num:
text.
X0701 -7001 Invalid default value name for column name.
X0801 -8001 Internal executor error.
X0802 -8002 The current nowaited operation is not complete.
X0803 -8003 The descriptor is locked by another nowaited operation.
X0806 -8006 The stream timed out, but the cursor is still open.
X0807 -8007 The operation has been canceled.
X080A -8010 Default catalog name: name. Default schema name: name.
X080B -8011 SELECT statement inside compound (BEGIN ... END)
statement returns more than one row.
X080C -8012 Encoding of CONTROL QUERY DEFAULTs: name.
X080E -8014 A SELECT statement within compound statement did not
return any row.
X080G -8016 An attempt was made to access name which has a system
version that is incompatible with the version of the accessing
software.
X080H -8017 Explain information is not available for this query.
X080J -8883
X08P1 -8901 The MXUDR server for this statement is no longer running.
The statement will be assigned a new MXUDR server if it is
executed again.
X08P2 -8902 Internal error: MXUDR returned an invalid UDR handle.
X08P3 -8903 An attempt was made by SQL/MX to kill the MXUDR server for
this statement process-name. PROCESS_STOP_ returned
value.
X08P4 -8904 Unable to receive reply from MXUDR, possibly caused by
internal errors while executing user-defined routines.
Table 22-1. SQLSTATE Values (page 72 of 84)
SQLSTATE SQLCODE Error Text










