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