The following table lists SQL Service edge returns that are sorted by XOPEN code.
Note: All non-00000 edges also follow the fail_operation edge.
XOPEN Code |
Edge |
Description |
---|---|---|
00000 |
Success, found | notfound |
The operation is successful. |
01000 |
A general warning is generated. |
|
01001 |
A cursor operation conflict has occurred. |
|
01002 |
A disconnect error has occurred. |
|
01004 |
The data is truncated. |
|
01006 |
The privilege is not revoked. |
|
01S00 |
An invalid connection string attribute exists. |
|
01S01 |
There is an error in a row. |
|
01S02 |
The option value is changed. |
|
07001 |
The wrong number of parameters are provided. |
|
07002 |
The parameters are mismatched. |
|
07003 |
The cursor specification cannot be executed. |
|
07004 |
Parameters are missing. |
|
07005 |
There is an invalid cursor state. |
|
07006 |
A restricted data type attribute violation has occurred. |
|
07008 |
There is an invalid descriptor count. |
|
08000 |
A connection exception has occurred. |
|
08001 |
A connection to the data source cannot be made (for example, invalid license key). |
|
08002 |
A connection is already in use. |
|
08003 |
A connection is not open. |
|
08004 |
The data source rejected a connection attempt. |
|
08007 |
A connection failure has occurred during a transaction. |
|
08900 |
The server lookup failed. |
|
08S01 |
A communication link failure has occurred. |
|
21000 |
A cardinality violation has occurred. |
|
21S01 |
An insert value list does not match the column list. |
|
21S02 |
The degree of a derived table does not match the column list. |
|
22000 |
A data exception has occurred. |
|
22001 |
String data has been truncated to the right. |
|
22003 |
The numeric value is out of range. |
|
22007 |
fail_syntax |
An invalid datetime format exists. |
22012 |
Division by zero has occurred. |
|
22018 |
An error in assignment exists. |
|
22026 |
The length of string data is mismatched. |
|
23000 |
An integrity constraint violation has occurred. |
|
25000 |
There is an invalid transaction state. |
|
25S02 |
The transaction is still active. |
|
25S03 |
The transaction has been rolled back. |
|
26000 |
The SQL statement identifier is invalid. |
|
28000 |
The authorization specification is invalid. |
|
34000 |
The cursor name is invalid. |
|
3C000 |
duplicate |
There is a duplicate cursor name. |
40000 |
The commit transaction resulted in a rollback transaction. |
|
40001 |
fail_timeout |
There is a serialization failure (for example, timeout or deadlock). |
42000 |
fail_syntax |
There is a syntax error or access rule violation. |
42S01 |
duplicate |
The base table or view already exists. |
42S02 |
fail_notfound |
The base table or view is not found. |
42S11 |
duplicate |
The index already exists. |
42S12 |
fail_notfound |
The index is not found. |
42S21 |
duplicate |
The column already exists. |
42S22 |
fail_notfound |
The column is not found. |
42S23 |
There is no default for the column. |
|
44000 |
A WITH CHECK OPTION violation has occurred. |
|
HY000 |
A general error has occurred. |
|
HY001 |
A storage allocation failure has occurred. |
|
HY002 |
The column number is invalid. |
|
HY003 |
The application buffer type is invalid. |
|
HY004 |
The SQL data type is invalid. |
|
HY008 |
The operation was cancelled. |
|
HY009 |
The use of a null pointer is invalid. |
|
HY010 |
A function sequence error has occurred. |
|
HY011 |
The operation is invalid at this time. |
|
HY012 |
The transaction operation code is invalid. |
|
HY015 |
No cursor name is available. |
|
HY018 |
The server declined a cancel request. |
|
HY090 |
There is an invalid string or buffer length. |
|
HY091 |
The descriptor type is out of range. |
|
HY092 |
The attribute or option type is out of range. |
|
HY093 |
The parameter number is invalid. |
|
HY095 |
The function type is out of range. |
|
HY096 |
The information type is out of range. |
|
HY097 |
The column type is out of range. |
|
HY098 |
The scope type is out of range. |
|
HY099 |
The nullable type is out of range. |
|
HY100 |
The uniqueness option type is out of range. |
|
HY101 |
The accuracy option type is out of range. |
|
HY103 |
The direction option is out of range. |
|
HY104 |
The precision or scale value is invalid. |
|
HY105 |
The parameter type is invalid. |
|
HY106 |
The fetch type is out of range. |
|
HY107 |
The row value is out of range. |
|
HY108 |
The concurrency option is out of range. |
|
HY109 |
The cursor position is invalid. |
|
HY110 |
The driver completion is invalid. |
|
HY111 |
The bookmark value is invalid. |
|
HYC00 |
The driver is not capable. |
|
HYT00 |
fail_timeout |
The timeout expired. |
HYT01 |
fail_timeout |
There is a timeout in some databases (not XOPEN standard). |
HZ010 |
An Access control violation RDA error has occurred. |
|
HZ020 |
A bad repetition count RDA error has occurred. |
|
HZ080 |
A resource not available RDA error has occurred. |
|
HZ090 |
A resource already open RDA error has occurred. |
|
HZ100 |
A resource unknown RDA error has occurred. |
|
HZ380 |
An SQL usage violation RDA error has occurred. |
|
IM001 |
The driver does not support this function. |
|
IM002 |
fail_notfound |
The data source name is not found and no default driver is specified. |
IM003 |
The specified driver could not be loaded. |
|
IM004 |
The AllocEnv property of the driver failed. |
|
IM005 |
The AllocConnect property of the driver failed. |
|
IM006 |
The SetConnectOption property of the driver failed. |
|
IM007 |
No data source or driver is specified. The dialog is prohibited. |
|
IM008 |
The dialog failed. |
|
IM009 |
The translation DLL could not be loaded. |
|
IM010 |
The data source name is too long. |
|
IM011 |
The driver name is too long. |
|
IM012 |
There is a driver keyword syntax error. |
|
IM013 |
There is a trace file error. |