![HP NonStop SQL/MX Messages Manual Download Page 679](http://html.mh-extra.com/html/hp/nonstop-sql-mx/nonstop-sql-mx_messages-manual_165150679.webp)
SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual — 640324-001
21 -27
SQLSTATE Values
01J03
7003
A plan using cluster sampling could not be produced for this
query.
01K01
8001
Internal executor error.
01K02
8002
The current nowaited operation is not complete.
01K03
8003
The descriptor is locked by another nowaited operation.
01K04
8004
Trying to open a statement or cursor that is not in the closed
state.
01K05
8005
Trying to fetch from a cursor that is not in the open state.
01K06
8006
The stream timed out, but the cursor is still open.
01K07
8007
The operation has been canceled.
01K08
8008
Catalog name
name
is invalid.
01K09
8009
Schema name
name
is invalid.
01K0A
8010
Default catalog name:
name
. Default schema name:
name
.
01K0B
8011
SELECT statement inside compound (BEGIN ... END)
statement returns more than one row.
01K0C
8012
Encoding of CONTROL QUERY DEFAULTs:
name
.
01K0D
8013
Trying to update or delete from a cursor that is not in the
fetched state.
01K0E
8014
A SELECT statement within a compound statement did not
return any row.
01K0F
8015
Aborting transaction because a compound statement
performed an update operation followed by a SELECT
statement that did not return any row.
01K0G
8016
An attempt was made to access
name
which has a system
version that is incompatible with the version of the accessing
software.
01K0H
8017
Explain information is not available for this query.
01K2S
8100
Define
name
does not exist
01K2T
8101
The operation is prevented by check constraint
name
on table
name
.
01K2U
8102
The operation is prevented by a unique constraint.
01K2V
8103
The operation is prevented by referential integrity constraint
name
on table
name
.
01K2W
8104
The operation is prevented by the check on view
name
cascaded from the check option on
name
.
01K2X
8105
The operation is prevented by the check option on view
name
.
01K3W
8140
The statement was canceled, to test cancel processing. File
name
at line
num
.
Table 21-1. SQLSTATE Values (page 26 of 84)
SQLSTATE
SQLCODE
Error Text
Summary of Contents for NonStop SQL/MX
Page 4: ......
Page 8: ...Contents HP NonStop SQL MX Messages Manual 640324 001 iv ...
Page 26: ...General Messages 0 through 999 HP NonStop SQL MX Messages Manual 640324 001 2 2 ...
Page 130: ...SQL MX MXCMP Messages 2000 through 2999 HP NonStop SQL MX Messages Manual 640324 001 4 34 ...
Page 242: ...Normalizer Messages 5000 through 5999 HP NonStop SQL MX Messages Manual 640324 001 7 2 ...
Page 246: ...Optimizer Messages 6000 through 6999 HP NonStop SQL MX Messages Manual 640324 001 8 4 ...
Page 248: ...Generator Messages 7000 through 7999 HP NonStop SQL MX Messages Manual 640324 001 9 2 ...
Page 614: ...Utility Messages 20000 through 23099 HP NonStop SQL MX Messages Manual 640324 001 18 138 ...
Page 752: ...Non SQLCODE Error Messages HP NonStop SQL MX Messages Manual 640324 001 A 14 MXGNAMES Utility ...