 Firebird 2.5 Language Reference. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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’s0 码力 | 521 页 | 2.30 MB | 1 年前3 Firebird 2.5 Language Reference. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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’s0 码力 | 521 页 | 2.30 MB | 1 年前3
 firebird 40 language reference. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 400 7.8.1. System Exceptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 494 8.12.5. RDB$SYSTEM_PRIVILEGE() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 576 13.1.4. Fine-grained System Privileges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .0 码力 | 778 页 | 3.43 MB | 1 年前3 firebird 40 language reference. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 400 7.8.1. System Exceptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 494 8.12.5. RDB$SYSTEM_PRIVILEGE() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 576 13.1.4. Fine-grained System Privileges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .0 码力 | 778 页 | 3.43 MB | 1 年前3
 Firebird 1.5 ErrorCodesno_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 Firebird 1.5 ErrorCodesno_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 attempted to perfrom an illegal operation. -901 335544784 exception_sigbus Bus Error. The Code caused a system bus error. -901 335544785 exception_sigfpe Floating Point Error. The Code caused an Arithmetic Exception 0 码力 | 26 页 | 85.09 KB | 1 年前3
 Firebird 2.0 ErrorCodesno_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 numeric value required -901 335544442 noargacc_read Database system cannot read argument %ld -901 335544443 noargacc_write Database system cannot write argument %ld -901 335544450 misc_interpreted %s0 码力 | 26 页 | 157.59 KB | 1 年前3 Firebird 2.0 ErrorCodesno_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 numeric value required -901 335544442 noargacc_read Database system cannot read argument %ld -901 335544443 noargacc_write Database system cannot write argument %ld -901 335544450 misc_interpreted %s0 码力 | 26 页 | 157.59 KB | 1 年前3
 Firebird 2.1 ErrorCodesno_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 numeric value required -901 335544442 noargacc_read Database system cannot read argument @1 -901 335544443 noargacc_write Database system cannot write argument @1 -901 335544450 misc_interpreted @10 码力 | 31 页 | 103.24 KB | 1 年前3 Firebird 2.1 ErrorCodesno_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 numeric value required -901 335544442 noargacc_read Database system cannot read argument @1 -901 335544443 noargacc_write Database system cannot write argument @1 -901 335544450 misc_interpreted @10 码力 | 31 页 | 103.24 KB | 1 年前3
 firebird 30 sprachreferenzEntwicklern 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 und0 码力 | 701 页 | 3.12 MB | 1 年前3 firebird 30 sprachreferenzEntwicklern 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 und0 码力 | 701 页 | 3.12 MB | 1 年前3
 firebird gsecthey know the SYSDBA password. This is because those operating systems allow the system administrator to set file system permissions which prevent execution of certain programs and utilities for security in the security database, and by doing so, allows users to be added, amended and deleted from the system. Up until Firebird 2.0, it used to be possible to use isql to connect directly to the security database databases at all. The password can be up to 8 characters long, but when supplying one to gsec, or logging into databases, the characters after the eighth are simply ignored. -uid firebird gsecthey know the SYSDBA password. This is because those operating systems allow the system administrator to set file system permissions which prevent execution of certain programs and utilities for security in the security database, and by doing so, allows users to be added, amended and deleted from the system. Up until Firebird 2.0, it used to be possible to use isql to connect directly to the security database databases at all. The password can be up to 8 characters long, but when supplying one to gsec, or logging into databases, the characters after the eighth are simply ignored. -uid- , -gid - -uid 0 码力 | 23 页 | 145.31 KB | 1 年前3
 firebird gfixof page buffers and so on. Gfix is a general purpose tool for system administrators (and database owners) to use to make various 'system level' changes to their databases. Almost all the gfix commands ps (or other) commands. To define the username and password as environment variables on a Linux system: Chapter 3. Gfix Commands 5 linux> export ISC_USER=sysdba linux> export ISC_PASSWORD=masterkey because it looks like the response code is always zero — at least up until Firebird 2.0.  When logging into a database on a remote server, you will always be required to pass the -u[ser] and -pa[ssword]0 码力 | 44 页 | 247.13 KB | 1 年前3 firebird gfixof page buffers and so on. Gfix is a general purpose tool for system administrators (and database owners) to use to make various 'system level' changes to their databases. Almost all the gfix commands ps (or other) commands. To define the username and password as environment variables on a Linux system: Chapter 3. Gfix Commands 5 linux> export ISC_USER=sysdba linux> export ISC_PASSWORD=masterkey because it looks like the response code is always zero — at least up until Firebird 2.0.  When logging into a database on a remote server, you will always be required to pass the -u[ser] and -pa[ssword]0 码力 | 44 页 | 247.13 KB | 1 年前3
 firebird 5 quickstartguidethis 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: 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 Installing the Firebird server 3.2.1. Before installation  If you’re installing Firebird on a system where Firebird has never been installed, you can skip this section. It is almost always advisable0 码力 | 49 页 | 396.21 KB | 1 年前3 firebird 5 quickstartguidethis 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: 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 Installing the Firebird server 3.2.1. Before installation  If you’re installing Firebird on a system where Firebird has never been installed, you can skip this section. It is almost always advisable0 码力 | 49 页 | 396.21 KB | 1 年前3
 firebird language reference 30 rusrdb$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(' firebird language reference 30 rusrdb$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 Таблица 0 码力 | 719 页 | 3.98 MB | 1 年前3
共 38 条
- 1
- 2
- 3
- 4













