. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 2. Responses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . deferring the read of the response. Chapter 1. Introduction 3 Chapter 2. Responses The wire protocol has a limited set of responses. Some operations have a specific response, which is described together together with the operation. Most operation however use one (or more) of the responses described in this section. The meaning and content depend on the operation that initiated the response. 2.1. Generic response

Firebird 2.1 Error Codes Firebird 2.1 Error Codes SQLCODE GDSCODE SYMBOL TEXT 101 335544366 segment Segment buffer length shorter than expected 101 335544366 segment Segment buffer length shorter than the security database -85 335544754 error_adding_sec_record An error occurred while attempting to add the user. -85 335544755 error_modifying_sec_record An error occurred while attempting to modify the 335544756 error_deleting_sec_record An error occurred while attempting to delete the user record. -85 335544757 error_updating_sec_db An error occurred while updating the security Firebird 2.1 Error Codes

Firebird 2.0 Error Codes Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT 101 335544366 segment Segment buffer length shorter than expected 100 335544338 from_no_match No match for first value the security database -85 335544754 error_adding_sec_record An error occurred while attempting to add the user. -85 335544755 error_modifying_sec_record An error occurred while attempting to modify the the user record. -85 335544756 error_deleting_sec_record An error occurred while attempting to delete the user record. -85 335544757 error_updating_sec_db An error occurred while updating the security

Firebird 1.5 Error Codes Firebird 1.5 Error Codes from msg.gbak, release sources SQLCODE GDSCODE SYMBOL TEXT 101 335544366 segment Segment buffer length shorter than expected 100 335544338 from_no_match the security database -85 335544754 error_adding_sec_record An error occurred while attempting to add the user. -85 335544755 error_modifying_sec_record An error occurred while attempting to modify the the user record. -85 335544756 error_deleting_sec_record An error occurred while attempting to delete the user record. -85 335544757 error_updating_sec_db An error occurred while updating the security

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 2.1.3. Error Conditions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 422 SQLSTATE Error Codes and Descriptions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 422 SQLCODE and GDSCODE Error Codes and Descriptions Chapter 2. SQL Language Structure 18 2.1.3. Error Conditions Processing of every SQL statement either completes successfully or fails due to a specific error condition. 2.2. Basic Elements: Statements

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 2.1.3. Error Conditions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 491 8.12.2. RDB$ERROR(). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 638 SQLSTATE Error Codes and Descriptions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 638 SQLCODE and GDSCODE Error Codes and Descriptions

B = B + 1; WHEN ANY DO BEGIN EXECUTE PROCEDURE LOG_ERROR ( CURRENT_TIMESTAMP, 'ERROR IN B LOOP'); LEAVE; END END C = 0; ... ANY DO BEGIN -- Записываем ошибку в журнал IN AUTONOMOUS TRANSACTION DO INSERT INTO ERROR_LOG (PSQL_MODULE, GDS_CODE, SQL_CODE, Доступно в: PSQL. Синтаксис: Процедурный язык PSQL 386 WHEN {<error> [, <error> ...] | ANY} DO <error> ::= { EXCEPTION exception_name | SQLCODE number | GDSCODE errcode

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 14. Error Handling And Exception Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . You should be aware that unless you also pass the username and password as well, you may see an error message telling you that your username or password have not been defined. In this case, you need -i(nput) input file (set input) -m(erge) merge standard error -m2 merge diagnostic -n(oautocommit) no autocommit DDL

Datumstyp umgewandelt. In Dialekt 3 wird diese Anweisung den Fehler 35544569 ausgeben, “`Dynamic SQL Error: expression evaluation not supported, Strings cannot be added or subtracted in dialect 3” — eine bevor ein einzelner Datensatz aus der Tabelle MY_TAB abgerufen wurde. Der Fehler isc_no_cur_rec error (no current record for fetch operation) wird ausgelöst und unterbricht die Ausführung. Die Lösung NUMBERS(B) VALUES (:B); B = B + 1; WHEN ANY DO BEGIN EXECUTE PROCEDURE LOG_ERROR ( CURRENT_TIMESTAMP, 'ERROR IN B LOOP'); LEAVE; END END C = 0; ... 2. Ein Beispiel für die Verwendung

failed, SQLCODE = -901 lock conflict on no wait transaction -I/O error for file "/home/norman/firebird/shadow/my_employee.shd2" -Error while trying to open file -No such file or directory -a file in manual transaction in database my_employee transaction is not in limbo -transaction 388 is active unknown ISC error 0 When committing or rolling back all limbo transactions, the -⁠pr[ompt] option can be specified my_employee SQL> create table test(stuff integer); Statement failed, SQLCODE = -902 Dynamic SQL Error -attempted update on read-only database SQL> quit; Chapter 8. Changing The Database Mode 16 linux>