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 expression| |-104|336003088|dsql\_datatypes\_not\_comparable|Datatypes %s are not comparable in expression %s| |SQLCODE|GDCODE|SYMBOL|TEXT| |---|---|---|---| |-104|335544343|invalid\_blr|Invalid request BLR at offset d expression in the %s (not contained in either an aggregate function or the GROUP BY clause)| |SQLCODE|GDCODE|SYMBOL|TEXT| |---|---|---|---| |-104|335544825|dsql\_agg\_having\_err|Invalid expression in

LOCALTIMESTAMP ..... 396 NEW ..... 398 'NOW' ..... 398 OLD ..... 399 ROW_COUNT ..... 400 SQLCODE ..... 401 SQLSTATE ..... 402 'TODAY' ..... 403 'TOMORROW' ..... 403 UPDATING сообщения ..... 549 Коды ошибок SQLSTATE и их описание ..... 549 Коды ошибок GDCODE их описание, и SQLCODE ..... 559 С. Зарезервированные и ключевые слова ..... 645 Зарезервированные слова ..... 645 Ключевые коды и сообщения: ## • Коды ошибок SQLSTATE и их описание • Коды ошибок GDCODE их описание, и SQLCODE ## Пользовательские исключения Пользовательские исключения могут быть объявлены в базе данных как

CURRENT_TRANSACTION CURRENT_USER DELETING GDCODE INSERTING NEW 'NOW' OLD ROW_COUNT SQLCODE SQLSTATE UPDATING 12. Операторы и предикаты Разрешено использование NULL как операнда || - конкатенация - ALTER USER - DROP USER ## Контекстные переменные Изменения начиная с Firebird 2.1: • Коды SQLCODE устарели (2.5.1) • Контекстная переменная SQLSTATE (2.5.1) ## Операторы и предикаты Изменения начиная $$ \begin{array}{l}WHEN ANY DO\\\quad BEGIN\\\quad INSERT INTO ERROR\_{L}OG(\ldots)\\\quad VALUES(SQLCODE,\ldots);\\\quad EXCEPTION;\\\quad END\end{array} $$ В этом примере сначала регистрируется некоторая

. 377 9.12. 'NOW' ..... 377 9.13. OLD ..... 378 9.14. ROW_COUNT ..... 379 9.15. SQLCODE ..... 379 9.16. SQLSTATE ..... 380 9.17. 'TODAY' ..... 381 9.18. 'TOMORROW' Appendix B: Exception Codes and Messages ..... 422 SQLSTATE Error Codes and Descriptions ..... 422 SQLCODE and GDSCODE Error Codes and Descriptions ..... 429 Appendix C: Reserved Words and Keywords ... ERROR_LOG (PSQL_MODULE, GDS_CODE, SQL_CODE, SQL_STATE) VALUES ('ADD_COUNTRY', GDSCODE, SQLCODE, SQLSTATE); -- Re-throw exception EXCEPTION; END See also CREATE EXCEPTION, WHEN ...

. 545 11.15. OLD ..... 546 11.16. RESETTING ..... 547 11.17. ROW_COUNT ..... 547 11.18. SQLCODE ..... 548 11.19. SQLSTATE ..... 548 11.20. 'TODAY' ..... 549 11.21. 'TOMORROW' Appendix B: Exception Codes and Messages ..... 638 SQLSTATE Error Codes and Descriptions ..... 638 SQLCODE and GDCODE Error Codes and Descriptions ..... 645 Appendix C: Reserved Words and Keywords .... procedure: • In a selectable procedure, the final END statement returns control to the caller, returning SQLCODE 100, indicating that there are no more rows to retrieve • In an executable procedure, the final

rm /home/norman/firebird/shadow/my_employee.shd2 linux_2> isql_my_employee Statement failed, SQLCODE = -901 lock conflict on no wait transaction -I/O error for file "/home/norman/firebird/shadow/my_employee isql my_employee Database: my_employee SQL> create table test(stuff integer); Statement failed, SQLCODE = -902 Dynamic SQL Error -attempted update on read-only database SQL> quit; linux> gfix -mode see the following: linux> isql my_employee -user norman -password whatever Statement failed, SQLCODE = -901 database my_employee shutdown Use CONNECT or CREATE DATABASE to specify a database SQL>

501 11.14. 'NOW' ..... 501 11.15. OLD ..... 502 11.16. ROW_COUNT ..... 503 11.17. SQLCODE ..... 504 11.18. SQLSTATE ..... 504 11.19. 'TODAY' ..... 506 11.20. 'TOMORROW' Gleichheit 574 Anhang B: Fehlercodes und Meldungen 575 SQLSTATE Fehlercodes und Beschreibungen 575 SQLCODE- und GDCODE-Fehlercodes sowie ihre Beschreibungen 582 Anhang C: Reservierte Wörter und Schlüsselwörter auswählbaren Prozedur gibt die letzte END-Anweisung die Kontrolle an den Aufrufer zurück und gibt SQLCODE 100 zurück, was angibt, dass keine weiteren Zeilen zum Abrufen vorhanden sind • In einer ausführbaren

isql, error messages comprise the SQLCODE variable and the Firebird status array. The following table provides some examples: Table 2. ISQL Error Codes and Messages SQLCODE Message Meaning <0 SQLERROR Error

..... 396 29.9.1. Setting Callbacks ..... 396 29.9.2. sqlca ..... 398 29.9.3. SQLSTATE vs SQLCODE ..... 399 29.10. Including Files ..... 401 29.11. Processing Embedded SQL Programs ..... 402 sqlca that has the following structure: struct { char sqlcaid[8]; long sqlabc; long sqlcode; struct { int sqlerrml; char sqlerrmc[70]; } sqlerrm; char sqlerrp[8]; error occurred in the last SQL statement, sqlca.sqlcode will be 0 and sqlca.sqlstate will be "00000". If a warning or error occurred, then sqlca.sqlcode will be negative and sqlca.sqlstate will be

..... 421 29.9.1. Setting Callbacks ..... 421 29.9.2. sqlca ..... 423 29.9.3. SQLSTATE vs SQLCODE ..... 424 29.10. Including Files ..... 426 29.11. Processing Embedded SQL Programs ..... 427 sqlca that has the following structure: struct { char sqlcaid[8]; long sqlabc; long sqlcode; struct { int sqlerrml; char sqlerrmc[70]; } sqlerrm; char sqlerrp[8]; error occurred in the last SQL statement, sqlca.sqlcode will be 0 and sqlca.sqlstate will be "00000". If a warning or error occurred, then sqlca.sqlcode will be negative and sqlca.sqlstate will be