this guide 3 Chapter 2. The Firebird licenses Firebird is a free, open-source database management system, but “free” does not mean that everything is permitted. The use of Firebird is governed by two licenses: also redistribute the software, separately or with a product of your own, but you may not claim ownership or credit for it. Any license notices included with Firebird must remain intact. • You may modify remnants of an old (and maybe long gone) InterBase or Firebird installation floating around your system (DLLs, Registry entries, environment variables…) 3.1. Installation kits At the Firebird website

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 301 7.7.1. System Exceptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 466 Appendix D: System Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . developers to communicate, through their applications, with the Firebird relational database management system. It has a long history. 1.1. Subject Matter The subject matter of this volume is wholly Firebird’s

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 400 7.8.1. System Exceptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 494 8.12.5. RDB$SYSTEM_PRIVILEGE() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 576 13.1.4. Fine-grained System Privileges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

using the SYSDBA account. -552 335544550 not_rel_owner Only the owner of a table may reassign ownership -552 335544553 grant_nopriv User does not have GRANT privileges for operation -552 335544707 no_meta_update Unsuccessful metadata update -607 335544549 systrig_update Cannot modify or erase a system trigger -607 335544657 dsql_no_blob_array Array/BLOB/DATE data types not allowed in arithmetic signal has been received -901 335544442 noargacc_read Database system cannot read argument -901 335544443 noargacc_write Database system cannot write argument -901 335544450 misc_interpreted

SQLCODE GDSCODE SYMBOL TEXT -552 335544550 not_rel_owner Only the owner of a table may reassign ownership -552 335544553 grant_nopriv User does not have GRANT privileges for operation -552 335544707 no_meta_update Unsuccessful metadata update -607 335544549 systrig_update Cannot modify or erase a system trigger -607 335544657 dsql_no_blob_array Array/BLOB/DATE data types not allowed in arithmetic TEXT -901 336723998 gsec_op_specified Operation already specified -901 336920607 gstat_sysmemex System memory exhausted -901 336330783 gbak_db_info_failed gds_$database_info failed -901 336723999 gsec_pw_specified

using the SYSDBA account. -552 335544550 not_rel_owner Only the owner of a table may reassign ownership -552 335544553 grant_nopriv User does not have GRANT privileges for operation -552 335544707 no_meta_update Unsuccessful metadata update -607 335544549 systrig_update Cannot modify or erase a system trigger -607 335544657 dsql_no_blob_array Array/BLOB/DATE data types not allowed in arithmetic failed -901 336723998 gsec_op_specified Operation already specified -901 336920607 gstat_sysmemex System memory exhausted -901 336330783 gbak_db_info_failed gds_$database_info failed -901 336723999 gsec_pw_specified

and 2.1 Quick Start 4 The Firebird licenses Firebird is a free, open-source database management system, but “free” does not mean that everything is per- mitted. The use of Firebird is governed by two also redistribute the software, separately or with a product of your own, but you may not claim ownership or credit for it. Any license notices included with Firebird must remain intact. • You may modify refers to the Win- dows system directory. Be sure to read the notes below the table, especially if you're running Firebird on a 64- bit Windows system. Table 3. Firebird 2 component locations

Entwicklern für die Kommunikation ihrer Anwendungen mit dem Firebird Relation Database Management System benötigt werden. 1.1. Thema Das Kernthema dieses Dokuments ist die vollständige Implementierung charakterisiert werden, dass jedes Byte Teil einer Zeichenkette ist, die Zeichenkette jedoch im System ohne Hinweise darauf gespeichert wird, was ein Zeichen darstellt: Zeichencodierung, Sortierung, vorherige Datei gemäß der angegebenen Seitenzahl vollständig mit Daten gefüllt ist, beginnt das System, der nächsten Datenbankdatei neue Daten hinzuzufügen. DIFFERENCE FILE Klausel, die den Pfad und

rdb$relation_type = t.rdb$type WHERE t.rdb$field_name = 'RDB$RELATION_TYPE' AND coalesce (r.rdb$system_flag, 0) = 0 Поле RDB$TYPE_NAME будет отображать Такое же значение можно будет получить и в результате выполнения запроса: SELECT RDB$GET_CONTEXT ('SYSTEM', 'CURRENT_ROLE') FROM RDB$DATABASE; См. также: RDB$GET_CONTEXT. CURRENT_TIME Синтаксис: RDB$GET_CONTEXT('', 'varname') ::= SYSTEM | DDL_TRIGGER | USER_SESSION | USER_TRANSACTION Таблица

API and ODS. The FIREBIRD Variable FIREBIRD is an optional environment variable that provides a system-level pointer to the root directory of the Firebird installation. If it exists, it is available everywhere on Windows (V.2.1) On Windows, the default authentication mode is “Mixed”, which allows operating system users with Local Administrator or Domain Administrator group privileges to attach to databases with blobs are no longer allowed. This affects not just user data but also the metadata stored in the system tables. There is a metadata script to enable you to upgrade the stored sources of triggers, stored