. . . . . . . . . . . . . . . . . . . . . . . . . . 18 10. Database Housekeeping And Garbage Collection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 10.1. 2. Cooperative Garbage Collection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 10.1.3. Background garbage Collection. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 10.1.4. Combined Garbage Collection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

onwards. -M[ETA_DATA] This switch causes your data to be ignored and not backed up or restored. In a backup, only the database meta data are backed up. When used in a restore, any data in the dump file creating database clones which are required to contain only the tables, indices etc but none of the data. -PAS[SWORD] Supplies the password for the username specified above. This need not be tables -E[XPAND] no data compression -FA[CTOR] blocking factor -G[ARBAGE_COLLECT) inhibit garbage collection -I[NACTIVE] deactivate

Note in V.2.1 Metadata Need to be Upgraded If your databases contain text BLOBs storing non-ASCII data then the backup/restore cycle is not enough to upgrade them to ODS 11.1. Please pay attention to the (V.2.1) Malformed UTF8 strings and text 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 allow Firebird to use indexes. Indexes Involving Data Type Coercion May Be Ignored (V.2.1) In cases where an indexed field and an argument have different data types and the implicit conversion cannot be performed

. . 24 3. Data Types and Subtypes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 3.1. Integer Data Types . . . Floating-Point Data Types. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 3.2.1. Approximate Floating-Point Data Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 3.3. Fixed-Point Data Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . 22 3. Data Types and Subtypes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 3.1. Integer Data Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 3.2. Floating-Point Data Types. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 3.3. Fixed-Point Data Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

success- fully. If you have enough privileges but invoking gsec results in a message like “unavailable data- base - unable to open database”, the server probably isn't running. In that case, go back to Testing for interactive SQL [utility]. You can use it for querying data, getting information about the metadata, creating database objects, running data definition scripts and much more. To get back to the command your serious database definition work, you should cre- ate and maintain your metadata objects using data definition scripts. There is a complete chapter in the Using Firebird manual discussing this topic

............................................................................... 366 ON EXTERNAL [DATA SOURCE] ........................................................................ 366 Особенности Зарезервированные и ключевые слова; • Типы и подтипы данных; • Операторы DDL (Data Definition Language — язык создания данных); • Операторы DML (Data Manipulation Language — язык обращения с данными); • Операторы управления NUMERIC(4) SMALLINT NUMERIC(4,2) SMALLINT (data * 102) NUMERIC(10,4) DOUBLE PRECISION в 1-ом диалекте BIGINT в 3-ем диалекте (data * 104) Внимание Всегда надо помнить

.............................................................................. 24 Protecting your data ................................................................................................. a database file can copy it, install it on a system under his or her own control, and extract all data from it – including possibly sensitive information. Anybody who has filesystem-level write access Aliases are listed in the file aliases.conf, in this format on Windows machines: poker = E:\Games\Data\PokerBase.fdb blackjack.fdb = C:\Firebird\Databases\cardgames\blkjk_2.fdb And on Linux: books =

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 7. Protecting your data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . access to a database file can copy it, install it on a system under their own control, and extract all data from it — including possibly sensitive information. Anybody who has filesystem-level write access own filesystem space and make embedded connections to them. Since these are their files and their data, one may argue that unrestricted and possibly destructive access should be their own concern, not

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 237 6. Data Manipulation-Statements (DML) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . gespeichert als INTEGER (exact data) DECIMAL(4,2) INTEGER (data * 102) DECIMAL(10,4) (Dialekt 1) DOUBLE PRECISION (Dialekt 3) BIGINT (data * 104) 3.4. Datentypen für Datum Typen "DATE", "TIME" und "TIMESTAMP". Der SQL-Standard ruft diese Datetime- Literale auf. Syntax <data_type> 'date_literal_string' Beispiel -- 1 UPDATE PEOPLE SET AGECAT = 'SENIOR' WHERE BIRTHDATE