Error codes
When an operation fails for a reason internal to GixSQL (consistency check, unsupported feature, driver problem…), SQLCODE is set to one of the following negative codes. The log gives more details (Logging).
| Name | SQLCODE |
Description |
|---|---|---|
DBERR_NO_ERROR |
0 | no error |
DBERR_CONNECTION_FAILED |
-100 | the connection to the database failed |
DBERR_BEGIN_TX_FAILED |
-101 | a transaction could not be started |
DBERR_END_TX_FAILED |
-102 | a transaction could not be ended |
DBERR_CONN_NOT_FOUND |
-103 | connection not found |
DBERR_CONN_RESET_FAILED |
-104 | the connection could not be closed |
DBERR_EMPTY_QUERY |
-105 | empty query |
DBERR_SQL_ERROR |
-106 | generic SQL or driver error |
DBERR_TOO_MANY_ARGUMENTS |
-107 | too many arguments |
DBERR_TOO_FEW_ARGUMENTS |
-108 | too few arguments |
DBERR_NO_PARAMETERS |
-109 | parameters were expected but not supplied |
DBERR_CURSOR_EXISTS |
-110 | the cursor already exists |
DBERR_NO_SUCH_CURSOR |
-111 | no such cursor |
DBERR_CLOSE_CURSOR_FAILED |
-112 | the cursor could not be closed |
DBERR_DISCONNECT_FAILED |
-113 | could not disconnect |
DBERR_OUT_OF_MEMORY |
-114 | out of memory |
DBERR_DECLARE_CURSOR_FAILED |
-115 | the cursor declaration failed |
DBERR_OPEN_CURSOR_FAILED |
-116 | the cursor could not be opened |
DBERR_FETCH_ROW_FAILED |
-117 | could not fetch a row |
DBERR_INVALID_COLUMN_DATA |
-118 | invalid column data |
DBERR_CURSOR_CLOSED |
-119 | the cursor is closed |
DBERR_MOVE_TO_FIRST_FAILED |
-120 | cannot move to the first row of a result set |
DBERR_FIELD_COUNT_MISMATCH |
-121 | the number of columns does not match the query |
DBERR_NO_DATA |
-122 | no rows when rows were expected |
DBERR_TOO_MUCH_DATA |
-123 | more rows than expected |
DBERR_PREPARE_FAILED |
-124 | the statement could not be prepared |
DBERR_CONN_INIT_ERROR |
-201 | connection initialization error |
DBERR_CONN_INVALID_DBTYPE |
-202 | invalid database type |
DBERR_NUM_OUT_OF_RANGE |
-410 | numeric value out of range |
DBERR_INTERNAL_ERR |
-8880 | internal error |
DBERR_NOT_IMPL |
-9990 | feature not implemented |