........................................................................................... 400 SQLCODE ................................................................................................ ....................................................... 549 Коды ошибок GDSCODE их описание, и SQLCODE ......................................................... 559 C. Зарезервированные и ключевые слова селективной процедуре последний оператор END возвращает управление приложению и устанавливает значение SQLCODE равным 100, что означает, что больше нет строк для извлечения; • В выполняемой процедуре последний

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 dsql_datatypes_not_comparable Datatypes %sare not comparable in expression %s Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT -104 335544343 invalid_blr Invalid request BLR at offset %ld -104 335544390 (not contained in either an aggregate function or the GROUP BY clause) Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT -104 335544825 dsql_agg_having_err Invalid expression in the %s (neither an

CURRENT_TIMESTAMP CURRENT_TRANSACTION CURRENT_USER DELETING GDSCODE INSERTING NEW 'NOW' OLD ROW_COUNT SQLCODE SQLSTATE UPDATING 12. Операторы и предикаты Разрешено использование NULL как операнда || USER - ALTER USER - DROP USER Контекстные переменные Изменения начиная с Firebird 2.1: • Коды SQLCODE устарели (2.5.1) • Контекстная переменная SQLSTATE (2.5.1) 16 Руководство по языку SQL Операторы вызов не имеет никакого эффекта. Пример: WHEN ANY DO BEGIN INSERT INTO ERROR_LOG (…) VALUES (SQLCODE, ...); EXCEPTION; END В этом примере сначала регистрируется некоторая информация об исключении

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 379 9.15. SQLCODE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 422 SQLCODE and GDSCODE Error Codes and Descriptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . • 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

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 547 11.18. SQLCODE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 638 SQLCODE and GDSCODE Error Codes and Descriptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . • 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

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 503 11.17. SQLCODE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 575 SQLCODE- und GDSCODE-Fehlercodes sowie ihre Beschreibungen . . . . . . . . . . . . . . . . . . . . . . . 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

linux_2> 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; Chapter 8. Changing will 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> Connections

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

........................................................................423 29.9.3. SQLSTATE vs SQLCODE...................................................................................424 29.10. Including with the name sqlca that has the following structure: struct { char sqlcaid[8]; long sqlabc; long sqlcode; struct { int sqlerrml; char sqlerrmc[70]; } sqlerrm; char sqlerrp[8]; long sqlerrd[6]; char sqlwarn[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 different

........................................................................398 29.9.3. SQLSTATE vs SQLCODE............................................................................399 29.10. Including with the name sqlca that has the following structure: struct { char sqlcaid[8]; long sqlabc; long sqlcode; struct { int sqlerrml; char sqlerrmc[70]; } sqlerrm; char sqlerrp[8]; long sqlerrd[6]; char sqlwarn[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 398 Chapter 29. ECPG - Embedded