ever seen on the very first page of the database, or, on the first page of each database file in a multi-file database. 0x02 The Page Inventory Page (PIP). This page keeps track of allocated and free pages a number of checks to ensure that the file is actually a database and so on. If the database is multi-file, then each file will have a header page of its own. The C code representation of the database metadata pages in the database. This field is only valid in the header page of the first file in a multi-file database. The remaining files in the database have this field set to zero. hdr_next_page Four

of the primary database file which for a single file database is simply the database name and for multi-file databases, it is the first data file added. Coming up in the remainder of this manual, we will -n(o_update) read-only validation (-v) -o(nline) database online multi / normal> -pr(ompt) prompt for commit/rollback (-l) -pa(ssword) default -sw(eep) force garbage collection -sh(utdown) shutdown multi> -tw(o_phase) perform automated two-phase recovery -tra(nsaction) shutdown transaction

indexed field is limited to 252 bytes with no COLLATE specified or 84 bytes if COLLATE is specified. Multi-byte character sets and Chapter 3. Data Types and Subtypes 34 compound indexes limit the size even than 2GB. Operations and Expressions Text BLOBs of any length and any character set — including multi-byte — can be operands for practically any statement or internal functions. The following operators subsequent files are called secondary file[s].  Multi-file Databases Nowadays, multi-file databases are considered an anachronism. It made sense to use multi-file databases on old file systems where the

indexed field is limited to 252 bytes with no COLLATE specified or 84 bytes if COLLATE is specified. Multi-byte character sets and compound indexes limit the size even further. Starting from Firebird 2.0 Chapter 3. Data Types and Subtypes 53 Text BLOBs of any length and any character set — including multi-byte — can be operands for practically any statement or internal functions. The following operators Arrays in Firebird are stored in BLOB of a specialized type. Arrays can be one-dimensional and multi-dimensional and of any data type except BLOB and ARRAY. Example CREATE TABLE SAMPLE_ARR ( ID INTEGER

mechanism to Chapter 4. Using generators to create unique row IDs 12 make this work safely in multi-user/multi-transaction environments, JUST DON’T DO IT! 4.4. Generators for IDs or auto-increment fields just inserted. You could grab the generator value from the client side after the Insert, but in multi-user environments you cannot be really sure that what you get is your own row’s ID (because of the any time from the “outside”. Although this can be very handy, it has a strong limitation: it’s not multi-user safe. If the SP would run simultaneously in two transactions, they would mess up the progress

fbk 1m norman_3.fbk fail to read input from ib_stdin, errno = 9 gsplit: progam fails to generate multi-volumn back-up files Done with volume #0, "stdout" Press return to reopen that file, or type GSPLIT description record gsplit: Exiting before completion due to errors gsplit: progam fails to join multi-volumn back-up files gbak: ERROR: expected backup description record gbak: Exiting before completion GSPLIT description record gsplit: Exiting before completion due to errors gsplit: progam fails to join multi-volumn back-up files Chapter 5. Joining Backup Files 7 Appendix A: Document history The exact

252 Byte begrenzt, wenn COLLATE nicht angegeben ist, oder 84 Byte, wenn `COLLATE ` ist angegeben. Multi-Byte-Zeichensätze und zusammengesetzte Indizes begrenzen die Größe noch weiter. Ab Firebird 2.0 Sekundärdatei(en) bezeichnet.  Mehrdatei-Datenbanken Heutzutage gelten Multi-File-Datenbanken als Anachronismus. Es war sinnvoll, Multi-File-Datenbanken auf alten Dateisystemen zu verwenden, bei denen die SALARY_HISTORY CREATE DESCENDING INDEX IDX_CHANGE ON SALARY_HISTORY (CHANGE_DATE); 3. Erstellen eines Multi-Segment-Index für die Spalten ORDER_STATUS, PAID in der Tabelle SALES CREATE INDEX IDX_SALESTAT

num_field_err Number of columns does not match select list -162 335544685 no_dbkey Dbkey not available for multi-table views -170 335544512 prcmismat Input parameter mismatch for procedure @1 -170 335544619 extern_func_err BLOB ID -901 335740937 gfix_trn_req Number of transactions per sweep required -901 336330761 gbak_multi_source_dest Multiple sources or destinations specified -901 335544330 bad_tpb_content Invalid parameter collation_name COLLATION @1 -901 335544871 domain_name DOMAIN @1 -901 335544874 max_db_per_trans_allowed A multi database transaction cannot span more than @1 databases -901 335544876 bad_proc_BLR Error while parsing

7, но, по-прежнему, в ней нет такой ключе- вой функции Firebird, как многоверсионная архитектура (multi-generational architecture, MGA), которая позволяет иметь «долгие» (по времени существования) транзакции данных, в том числе при непредвиденных сбоях. СУБД Firebird использует многовер- сионную архитектуру (multi-generation architect, MGA) для создания копии (версии) записи «на месте», если это необходимо (например

размер BLOB поля несколько ниже 2 Гб. Текстовые BLOB любой длины и с любым набором символов (включая multi-byte) могут быть использованы практически c любыми встроенными функциями и операторами: • Полная языкового стандарта. Требуется полная версия библиотеки ICU. Формат строки: «du_NL» (без кавычек). MULTI-LEVEL 0, 1 1 bpc Использование нескольких уровней сортировки. NUMERIC-SORT 0, 1 UNI Обрабатывает Число столбцов не соответствует списку выборки. -162 335544685 no_dbkey Dbkey not available for multi - table views. Значение Dbkey не доступно для мультитабличных view. -170 335544512 prcmismat Input