SQL Service Edge Returns Sorted by XOPEN Code

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