5.2. SHADOW. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87 5.2.1. CREATE SHADOW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87 5.2.2. DROP SHADOW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . [DIFFERENCE FILE 'diff_file'] -- not supported in ESQL ::= "'" [server_spec]{filepath | db_alias} "'" ::= servername[/{port|service}]: | \\servername\ ::= FILE 'filepath'

5.2. SHADOW. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117 5.2.1. CREATE SHADOW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117 5.2.2. DROP SHADOW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 714 RDB$DB_CREATORS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

.................. 99 SHADOW ................................................................................................................................. 99 CREATE SHADOW ...................... ............................................................ 100 Необязательные параметры CREATE SHADOW .............................................. 101 Кто может создать теневую копию? ........... ...................................................................................... 101 DROP SHADOW ................................................................................................

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104 5.2. SHADOW. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 5.2.1. CREATE SHADOW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105 5.2.2. DROP SHADOW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 641 RDB$DB_CREATORS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

rd An error occurred while attempting to delete the user record. -85 335544757 error_updating_sec_db An error occurred while updating the security database. Firebird 1.5 Error Codes Updated 04/30/04 from DOUBLE PRECISION in SQL dialect 1 to 64-bit scaled integer in SQL dialect 3 -104 336003077 sql_db_dialect_dtype_unsupport Database SQL dialect does not support reference to datatype dsql_shadow_number_err Shadow number must be a positive integer -599 335544607 node_err Gen.c: node not supported -599 335544625 node_name_err A node name is not permitted in a secondary, shadow, cache

d An error occurred while attempting to delete the user record. -85 335544757 error_updating_sec_db An error occurred while updating the security database. -103 335544571 dsql_constant_err Data type from DOUBLE PRECISION in SQL dialect 1 to 64-bit scaled integer in SQL dialect 3 -104 336003077 sql_db_dialect_dtype_unsupport Database SQL dialect %d does not support reference to %s datatype -104 336003087 dsql_shadow_number_err Shadow number must be a positive integer -599 335544607 node_err Gen.c: node not supported -599 335544625 node_name_err A node name is not permitted in a secondary, shadow, cache

rd An error occurred while attempting to delete the user record. -85 335544757 error_updating_sec_db An error occurred while updating the security Firebird 2.1 Error Codes database. -103 335544571 from DOUBLE PRECISION in SQL dialect 1 to 64-bit scaled integer in SQL dialect 3 -104 336003077 sql_db_dialect_dtype_unsupport Database SQL dialect @1 does not support reference to @2 datatype -104 336003087 dsql_shadow_number_err Shadow number must be a positive integer -599 335544607 node_err Gen.c: node not supported -599 335544625 node_name_err A node name is not permitted in a secondary, shadow, cache

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 4. Shadow Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . manual, we will discuss the following: • Command line options for the gfix database utility. • Shadow file handling. • Cache and buffer handling. • Transaction management. • Cache management. • Starting for Firebird 3.0.7 usage: gfix [options] plausible options are: -ac(tivate_shadow) activate shadow file for database usage -at(tach) shutdown new database attachments -b(uffers)

PAGES, PASSWORD, PRIVILEGES, PROTECTED, READ, RESERV, RESERVING, RETAIN, SCHEMA, SEGMENT, SHADOW, SHARED, SINGULAR, SIZE, SNAPSHOT, SORT, STABILITY, STARTING, STARTS, STATEMENT, STATISTICS слова: AUTODDL, BASE_NAME, BASED, BLOBEDIT, BUFFER, CHECK_POINT_LENGTH, COMPILETIME, CONTINUE, DB_KEY, DEBUG, DESCRIBE, DISPLAY, ECHO, EDIT, EVENT, EXTERN, FOUND, GOTO, GROUP_COMMIT_, HELP, IMMEDIATE PROTECTED 22 Руководство по языку SQL READ RESERV RESERVING RESTRICT RETAIN ROLE SCHEMA SEGMENT SHADOW SHARED SINGULAR SIZE SNAPSHOT SORT STABILITY STARTING STARTS STATEMENT STATISTICS SUB_TYPE SUSPEND

дополнительный модуль к СУБД Firebird), временные таблицы и интеграция с другими СУБД посредством OLE DB. Также в MS SQL встроены сервисы ана- лиза OLAP и полнотекстовый поисковый механизм (эта поддержка ). Дополнительная возможность, предоставляемая СУБД Firebird - это использование теневых файлов (shadow files). Теневые файлы являются немедленной копией исходной базы данных. Обычно они ис- пользуются двойные кавычки, но по умолчанию эта возможность доступна только при доступе через OLE DB и ODBC, но не при доступе через DB-Library. По этой причине такую практику работы следует избегать. СУБД MS SQL 7 и