. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44 3.5.2. Client Character Set . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161 5.5.4. SET STATISTICS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 237 5.14.6. SET GENERATOR. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 148 5.5.4. SET STATISTICS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 224 5.14.6. SET GENERATOR. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17. CHARACTER SET. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 236 5.17.1. ALTER CHARACTER SET . . . . . .

............................................................................................ 142 SET STATISTICS ....................................................................................... ............................................................................................ 225 SET GENERATOR ........................................................................................ ............. 235 CHARACTER SET ................................................................................................................. 235 ALTER CHARACTER SET .............................

. . . . . . . . . . . . . . . . . . . . . . . 32 Table of Contents 2 3.5.2. Client Character Set . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 128 5.5.4. SET STATISTICS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 168 5.11.3. SET GENERATOR. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

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 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 bytes, unsigned. Bytes 0x18 - 0x1b

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 5. Set Database Page Buffers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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 for database usage -at(tach) shutdown new database attachments -b(uffers) set page buffers -co(mmit) commit transaction -ca(che) shutdown

or decrease it just like a “var i:integer” in Delphi, but it is not always easy to “predictably” set it directly to a certain value and then obtain that same value — it’s inside the database, but outside dialect 1! 2.4.1. Client dialects and generator values Clients talking to a Firebird server can set their dialect to 1 or 3, regardless of the database they are connected to. It is the client dialect Don’t even think of something like “OK, when I rollback, I can just do GEN_ID(mygen,-1) afterwards to set it back to 4”. This may work most of the time, but is unsafe because other concurrent transactions

Attempt to fetch past the last record in a record stream 0 335741039 gfix_opt_SQL_dialect -sql_dialect set database dialect n 0 335544875 bad_debug_format Bad debug info format -84 335544554 nonsql_security_rel 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 stream_not_defined Reference to invalid stream number -204 335544509 charset_not_found CHARACTER SET @1 is not defined -204 335544511 prcnotdef Procedure @1 is not defined -204 335544515 codnotdef Status

7, но, по-прежнему, в ней нет такой ключе- вой функции Firebird, как многоверсионная архитектура (multi-generational architecture, MGA), которая позволяет иметь «долгие» (по времени существования) транзакции данных, в том числе при непредвиденных сбоях. СУБД Firebird использует многовер- сионную архитектуру (multi-generation architect, MGA) для создания копии (версии) записи «на месте», если это необходимо (например до 263-1 (+922337203685477.5807), точность до 1/10000 денежной единицы. 7 nchar CHAR(x) CHARACTER SET UNICODE_FSS Символные данные фиксированной длины (Unicode). Максимальная длина 4000 сим- волов. 7

Attempt to fetch past the last record in a record stream 0 335741039 gfix_opt_SQL_dialect -sql_dialect set database dialect n -84 335544554 nonsql_security_rel Table/procedure has non-SQL security class defined 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 %s -170 335544619 extern_func_err stream_not_defined Reference to invalid stream number -204 335544509 charset_not_found CHARACTER SET %s is not defined Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT -204 335544511 prcnotdef