amongst Firebird users world-wide to raise funds to pay for a professional translation into English, from which translations into other languages would proceed under the auspices of the Firebird Documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 187 6.1.3. The FROM clause . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . SQL relational database language. Firebird conforms closely with international standards for SQL, from data type support, data storage structures, referential integrity mechanisms, to data manipulation

fragments (-v) -fo(rce_shutdown) force database shutdown -fe(tch_password) fetch password from file -h(ousekeeping) set sweep interval -i(gnore) ignore checksum errors file name> | stdin | /dev/tty This switch causes the password for the appropriate user to be read from a file as opposed to being specified on the command line. The file name supplied is not in quotes result in other users of the server seeing that password using a command like ps -efx | grep -i pass. From Firebird 2 onwards, this is no longer the case as the password on the command line can no longer

.............................................................................................. 7 Linux ................................................................................................. or higher ASAP and make sure to read your new version's Release Notes. • If you want to rely on Linux forced writes to work correctly, upgrade to at least 2.0.4. Firebird 2.0 and 2.1 Quick Start 4 Developer's Public License). The first one covers the parts of the source code that were inherited from InterBase; the second applies to the additions and improvements made by the Firebird Project. Both

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 3.2.6. Installing on Linux and other Unix-like platforms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 3.5.2. Linux and some other POSIX clients . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 4.1. Linux . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

............................................................................................. 16 Linux and some other Posix clients .................................................................... available (at least for 1.0 versions) so you can skip this section, but if you're in- stalling on Linux you're faced with the choice. Which one is better? Well, that depends on your situ- ation. A short 0 Classic Server vs. Superserver Classic Server Superserver Only available on Linux. Available on both Windows and Linux. Creates a process for each client connec- tion, each with its own cache. Less

console commands. The isql utility can be used in three modes: as an interactive session; directly from the command line; and as a non-interactive session, using a shell script or batch file. Different be performed in each of the modes, as illustrated below: • An interactive session can be invoked from the command line of the operating system shell, and lasts until the session is terminated, using modify data. ◦ Grant user permissions. ◦ Perform database administrative functions. • Directly from the command line, with individual options and without starting an interactive session. Commands execute

.......................................................................... 24 Installing Firebird from a zip kit ....................................................................................... ................................................................... 25 Installing Classic Server from a zip kit .................................................................................. 25 Simplified ............................................................................................. 34 Linux Platforms .......................................................................................

file name> | stdin | /dev/tty This switch causes the password for the appropriate user to be read from a file as opposed to being specified on the command line. The file name supplied is not in quotes owner, however, if the -c(reate) switch is used, any validated username can create a new database from a backup file. Chapter 2. Command-line Options 3 -V[ERIFY] Normally gbak operates quietly with database employee Firebird/linux (access method),version LI-V2.1.3.18185 Firebird 2.1 Firebird/linux (remote server),version LI-V2.1.3.18185 Firebird 2.1/tcp (tux)/P11 Firebird/linux (remote interface), version

текстовым BLOB Общие табличные выражения (“WITH ... AS ... SELECT”) Производные таблицы (“SELECT FROM SELECT”) FIRST и SKIP GROUP BY HAVING: Более строгие правила JOIN 4 Руководство по языку SQL UNION как подзапрос IN Разрешено использование NULL UNION как подзапрос IS [NOT] DISTINCT FROM NEXT VALUE FOR SIMILAR TO Создание регулярных выражений SOME 13. Агрегатные функции LIST() 0X6FAA0D3 FROM RDB$DATABASE -- возвращает 117088467 SELECT 0X4F9 FROM RDB$DATABASE -- возвращает 1273 SELECT 0X6E44F9A8 FROM RDB$DATABASE -- возвращает 1850014120 SELECT 0X9E44F9A8 FROM RDB$DATABASE

Datenbankdateien für lokale Verbindungen unter Linux. Der Clientpro- zess muss Zugriffsrechte auf Dateisyste- mebene auf die Datenbank besitzen. Unter Linux werden alle lokalen Ver- bindungen über die Netzwerkschicht irreführend), dann verwenden Sie die folgende Faustregel: • Unter Windows: Superserver. • Unter Linux: Wählen Sie irgendeine Architektur. In den meisten Fällen werden Sie keinen Performanceun- terschied Datenbanken werden, so wie vor dem Umstieg, funktionsfähig bleiben. Firebird 2 Schnellanleitung 5 Für Linux beginnen die Download-Pakete für Superserver mit FirebirdSS, Classic Pakete mit Firebird- CS. Für