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 can not 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. |
iWay Software |