databases will keep func- tioning like before. For Linux, Superserver download packages start with FirebirdSS, Classic packages with FirebirdCS. For Windows, there is a combined installation package; you grey server symbol if controlled by the Guardian; • A round yellow and black graphic if running standalone. A flashing icon indicates that the server is in the process of starting up (or at least trying net/projects/firebird/. At that Firebird 2.0 and 2.1 Quick Start 32 site are the source code tree, the download packages and a number of technical files related to the development and testing of the codebases. The Firebird

Candidate 1) and p the packaging number (usually 0 or another low one-digit number). Firebird 5 packages will also undoubtedly wind up in various Linux distributions and their online repositories. These step. 3.4.2. Making sure that the Firebird server is running Most — but not all — installation packages start up the Firebird server as one of the final steps during installation, and also make sure grey server symbol if controlled by the Guardian; • A round yellow and black graphic if running standalone. A flashing icon indicates that the server is in the process of starting up (or at least trying

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64 19.15. SHOW PACKages. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . GRANTs INDexes INDICES MAPping PROCedures PACKages ROLEs SYStem SEQuences SECURITY CLAsses OUTPUT VARCHAR(15) 19.15. SHOW PACKages Added in Firebird 3.0 SQL> SHOW PACKages [name]; This command lists all the user-defined packages in the current database if the first form is

7.5. Packages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 351 7.5.1. Benefits of Packages. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 731 RDB$PACKAGES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . and external (legacy) functions, excluding sub-functions or functions in packages. For sub-functions or functions in packages, the name must be unique within its module (package, stored procedure, stored

...................................................................................... 671 RDB$PACKAGES ............................................................................................... пакета сохраняется. Состояние соответствия тела пакета его заголовку отображается в столбце RDB$PACKAGES.RDB$VALID_BODY_FLAG. Кто может изменить заголовок пакета? Выполнить оператор ALTER PACKAGE могут: исходный код тела пакета сохраняется. При этом код тела пакета может стать невалидным. Столбец RDB$PACKAGES.RDB $VALID_BODY_FLAG отображает состояние тела пакета. См. также: ALTER PACKAGE, ALTER PACKAGE

call the Services Manager and you switch to Classic). Superserver download packages start with FirebirdSS, Classic packages with FirebirdCS. As said, this only goes for Linux. Firebird 1.0 Quick Start

to use rpm --update to bring any existing Firebird package installation up to date. The Firebird packages do not support it. • If you are installing Superserver on a Linux that supports the “new POSIX replacing the CS with SS. Installing on POSIX Platforms 40 Uninstalling an RPM package For rpm packages: $rpm -e FirebirdCS-2.1.n Uninstalling a tarball installation for the .tar.gz install:

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 657 RDB$PACKAGES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . inkompatibel ist. Die Gültigkeit eines Paketkörpers für den definierten Header wird in der Spalte RDB$PACKAGES.RDB$VALID_BODY_FLAG gespeichert. Wer kann ein Paket ändern Die ALTER PACKAGE-Anweisung kann ausgeführt Datenbankindizes (System- und Benutzerdefiniert) RDB$LOG_FILES In derzeitigen Versionen nicht verwendet RDB$PACKAGES Speichert die Definition (Header und Body) von SQL-Paketen RDB$PAGES Informationen über Datenbankseiten

CHARACTER SET UTF8 SET DEFAULT COLLATION UNICODE_CI_AI; 5.15. ROLE A role is a database object that packages a set of SQL privileges. Roles implement the concept of access control at a group level. Multiple run-time execution with EXECUTE BLOCK. Firebird 3 will encompass more module types (stored functions, packages). Any module that fails to recompile because of an incompatibility arising from a domain change