databases, ◦ numbers (DECIMAL and NUMERIC data types) are stored internally as long fixed point values (scaled integers) when the precision is greater than 9. ◦ The TIME data type is available for storing time-of-day how to back up a database in two quite different ways and how to switch the database to the “copy-safe” mode for performing an external backup safely. 5.1.1. CREATE DATABASE Used for Creating a new file delta that stores any mutations to the database file after it has been switched to the “copy-safe” mode by the ALTER DATABASE BEGIN BACKUP statement. For the detailed description of this clause,

make direct local connections, but these are not as fast as the “Classic” ones on Linux and also less safe. Server must run as root. This poses a risk if the server were to be hacked or contained a severe Superserver, without using the TCP/IP loop- back. This is not a TCP/IP connection and it is not a thread-safe way to connect to a local server. For using single instances of the command-line tools (gsec, gbak contrast, direct database connections - even multiple - under a Linux Classic server are completely safe. Firebird 1.0 Quick Start Guide 11 Default user name and password The SYSDBA user has all privileges

databases, ◦ numbers (DECIMAL and NUMERIC data types) are stored internally as long fixed point values (scaled integers) when the precision is greater than 9. ◦ The TIME data type is available for storing time-of-day returns it in its simplest form QUANTIZE takes two DECFLOAT arguments and returns the first argument scaled using the second value as a pattern TOTALORDER performs an exact comparison on two DECFLOAT values how to back up a database in two quite different ways and how to switch the database to the “copy-safe” mode for performing an external backup safely. 5.1.1. CREATE DATABASE Used for Creating a new

access rights to the database file. Local connections On Windows, both architectures now support safe and reliable local connec- tions, with only the server process requiring access rights to the database Install Superserver first; • Copy the applet Firebird2Control.cpl from the Windows system folder to a safe place; • Uninstall Superserver; • Install Classic; • Copy the applet back to the system directory integer/integer division to a float quotient, you will need to alter any affected expressions to use a float or scaled numeric type for either dividend, divisor, or both. For example, the calculation above could be

always affect the accounts in the security database that governs that specific database. To be on the safe side, you may want to connect to the security database itself before issuing your user management division to a float quotient, you will need to alter any affected expressions to use a float or scaled numeric type for either dividend, divisor, or both. For example, the calculation above could be

записываться изменения, внесённые в БД после перевода её в режим «безопасного копирования» («copy-safe») путём выполнения команды ALTER DATABASE BEGIN BACKUP. Полное описание данного параметра см. в ALTER записываться изменения, внесённые в базу данных после перевода её в режим «безопасного копирования» («copy-safe»). Этот оператор в действительности не добавляет файла. Он просто переопределяет умалчиваемые имя Предложение BEGIN BACKUP предназначено для перевода базы данных в режим «безопасного копирования» («copy-safe»). Этот оператор «замораживает» основной файл базы данных, что позволяет безопасно делать резервную

Sekundärdateien zu einer Datenbank hinzufügen • Umschalten einer Einzeldatei-Datenbank in den “copy-safe”-Modus (nur DSQL) • Pfad und Name der Delta-Datei für physische Backups setzen oder aufheben (nur Namen der .delta-Datei aus dem Datenbank-Header. Wenn die Datenbank das nächste Mal in den “copy-safe”-Modus geschaltet wird, werden die Standardwerte verwendet (d. h. der gleiche Pfad und Name wie die den “kopiersicher” Modus: ALTER DATABASE BEGIN BACKUP; 5. Zurückschalten der Datenbank vom “copy-safe”-Modus in den normalen Betriebsmodus: ALTER DATABASE END BACKUP; 6. Ändern des Standardzeichensatzes

dsql_transitional_numeric Precision 10 to 18 changed 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

dsql_transitional_numeric Precision 10 to 18 changed 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

dsql_transitional_numeric Precision 10 to 18 changed 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