installation instructions correctly, there should be nothing for you to do upon completion but log in and go! 3.2.4. Server modes Some installers ask you to choose between Classic, SuperClassic and SuperServer it. If security is a concern (as it should be), you should not use the Legacy_Auth authentication plugin or enable it only temporarily while you upgrade your existing clients to Firebird 5.0. The legacy example, if your server’s IP address in the domain that is visible to your client is 192.13.14.1, go to a command shell on the client machine and type the command ping 192.13.14.1 substituting this

Chapter 3. Invoking Isql If you do not have the Firebird bin directory on your path, then either go to the bin subdirectory of your Firebird installation and type isql (Windows) or ./isql (Linux) at is only displayed from Firebird version 2.0 onwards, and some options — for example “Wire crypt plugin” — depend on the type of connection. SQL> show database; Database: localhost:employee Owner: Transaction - oldest snapshot = 237 Transaction - Next = 244 ODS = 13.0 Database not encrypted Wire crypt plugin: ChaCha Default Character set: NONE No parameters, such as a specific database name, are required

password Password of the user as the database owner. When using the Legacy_Auth authentication plugin, only the first 8 characters are used. Case-sensitive rolename The name of the role whose rights DEFAULT CHARACTER SET charset Chapter 5. Data Definition (DDL) Statements 110 | {ENCRYPT WITH plugin_name [KEY key_name] | DECRYPT} | SET LINGER TO linger_duration | DROP LINGER | SET DEFAULT Duration of linger delay in seconds; must be greater than or equal to 0 (zero) plugin_name The name of the encryption plugin Chapter 5. Data Definition (DDL) Statements 111 Parameter Description key_name

DEFAULT CHARACTER SET charset | SET LINGER TO linger_duration | DROP LINGER | {ENCRYPT WITH plugin_name [KEY key_name] | DECRYPT} ::= ADD [ ...] linger_duration Dauer der linger Verzögerung in Sekunden; muss größer oder gleich 0 (null) sein plugin_name Der Name des Verschlüsselungs-Plugins key_name Der Name des Verschlüsselungsschlüssels Die linger-verzögerung von 30 Sekunden ALTER DATABASE SET LINGER TO 30; 8. Verschlüsseln der Datenbank mit einem Plugin namens DbCrypt Chapter 5. Anweisungen der Datendefinitionssprache (DDL) 103 ALTER DATABASE ENCRYPT

| {SET DEFAULT CHARACTER SET charset} | {SET LINGER TO seconds | DROP LINGER} | {ENCRYPT WITH plugin_name [KEY key_name] | DECRYPT}; Операторы DDL 95 ::= ADD FILE файла. charset Новый набор символов по умолчанию для базы данных. seconds Задержка в секундах. plugin_name Имя плагина шифрования. key_name Имя ключа шифрования. Оператор ALTER DATABASE изменяет структуру предопределённой группы DOMAIN_ANY_RID_ADMINS на роль RDB$ADMIN. CREATE MAPPING WIN_ADMINS USING PLUGIN WIN_SSPI FROM Predefined_Group DOMAIN_ANY_RID_ADMINS TO ROLE RDB$ADMIN;

follow the instructions correctly, there should be nothing for you to do upon completion but log in and go! Windows platforms If you install Firebird 1.03 or higher under Windows 95/98/ME, uncheck the option attempted to document any known issues. Tip If you do not find a copy of the release notes in your kit, go back to the Downloads page of the Fire- bird website at http://firebird.sourceforge.net and download For example, if your server's IP address in the domain that is visible to your client is 192.13.14.1, go to a command shell and type the command ping 192.13.14.1 substituting this example IP address for

different. In the same vein, the System32 directory is reserved for 64-bit libraries. 32-bit libraries go into SysWOW64. That's right: 64-bit libraries are in System32, 32-bit libraries in SysWOW64. If you're installation instructions correctly, there should be nothing for you to do upon completion but log in and go! Firebird 2.0 and 2.1 Quick Start 10 Installing on Windows The Firebird installer lets you choose For example, if your server's IP address in the domain that is visible to your client is 192.13.14.1, go to a command shell on the client machine and type the command ping 192.13.14.1 substituting this

already have an earlier version of Firebird or InterBase® on your server and you think you might want to go back to it, set up your fall-back position before you begin: - Use the existing version of gbak to fdb, using the directions in the chapter entitled “Security” in the Firebird 2.0.x Release Notes. - Go to your System directory and make backup copies of fbclient.dll and/or gds32.dll if you have appli- worry about this if you run an uninstall. However, if you do have problems later this is something to go back and check. • Before installing Firebird 2.1 it is recommended that you uninstall a previous version

Firebird uses a page cache to hold pages in memory. It is much quicker to retrieve pages from RAM than to go out onto the disc system and read them physically each time they are required. The following description where to find the data pages for the tables involved in the application’s transactions. All the pages go into the cache and stay there until the cache is completely full. When there’s no place to put the are changed versus the number of times the pages were written to disk. When you see the disk writes go up, you’ve probably reduced the cache too much. Chapter 2. The Firebird Cache 3 Chapter 3. Using

that contain NULL or may resolve to NULL. If you only need a quick reference to refresh your memory, go to the summary at the end of the guide. So — what is it? In SQL, NULL is not a value. It is a state vast majority of cases the results will be correct. In such a situation those rare NULL cases may go unnoticed for a long time, silently corrupting your data. 9.2. CASE expression Firebird introduced adventure games in this table when you decide to add a non- nullable ID field. There are two ways to go about this, both with their own specific problems. 15.1.1. Adding a NOT NULL field This is by far