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 will not be restored. This employee Firebird/linux (access method),version LI-V2.1.3.18185 Firebird 2.1 Firebird/linux (remote server),version LI-V2.1.3.18185 Firebird 2.1/tcp (tux)/P11 Firebird/linux (remote interface), version LI-V2 -L[IMBO] If you have a two-phase transaction (across two different databases) that failed because a server died before the commit, but after the changes were made, you have a limbo transaction. This switch

checking than 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 determines how Firebird passes generator values to the client: • If the client dialect is 1, the server returns generator values as truncated 32-bit integers to the client. But inside the database they client). This is true both for dialect 1 and dialect 3 databases. • If the client dialect is 3, the server passes the full 64-bit value to the client. Again, this holds whether the database dialect is 1

.................................................................................... 5 Embedded Server for Windows .................................................................................... ...................................................................... 9 Installing the Firebird server ................................................................................................ ............................................................................................. 14 Server configuration and management ...................................................................

reference -104 335544714 invalid_array_id Invalid blob id -104 335544730 cse_not_supported Client/Server Express not supported in this release -104 335544743 token_too_long Token size exceeds limit -104 dimension range -605 335544682 dsql_field_ref Inappropriate self-reference of column -607 335544351 no_meta_update Unsuccessful metadata update -607 335544549 systrig_update Cannot modify or erase a system Variable conflicts with parameter in same procedure -901 335544666 srvr_version_too_old Server version too old to support all CREATE DATABASE options -901 335544673 no_delete Cannot delete -901

........................................................................ 7 Installation mehrerer Server ................................................................................................ Komponenten, die für die Installation des Firebird Servers benötigt wer- den: • Die ausführbare Firebird Server Datei. • Eine oder mehrere Clientbibliotheken. • Die Kommandozeilentools. • Die Standardbibliotheken Notes – UNBEDINGT LESEN! Classic oder Superserver? Firebird kommt in zwei Architekturen: Classic Server und Superserver. Welche sollten Sie installieren? Das hängt von Ihren Anforderungen ab. Einen kurzen

reference -104 335544714 invalid_array_id Invalid blob id -104 335544730 cse_not_supported Client/Server Express not supported in this release -104 335544743 token_too_long Token size exceeds limit -104 Data type %s is not supported for EXTERNAL TABLES. Relation '%s', field '%s' -607 335544351 no_meta_update Unsuccessful metadata update -607 335544549 systrig_update Cannot modify or erase a system dsql_var_conflict Variable %s conflicts with parameter in same procedure -901 335544666 srvr_version_too_old Server version too old to support all CREATE DATABASE options -901 335544673 no_delete Cannot delete

reference -104 335544714 invalid_array_id Invalid blob id -104 335544730 cse_not_supported Client/Server Express not supported in this release -104 335544743 token_too_long Token size exceeds limit -104 b Data type @1 is not supported for EXTERNAL TABLES. Relation '@2', field '@3' -607 335544351 no_meta_update Unsuccessful metadata update -607 335544549 systrig_update Cannot modify or erase a system dsql_var_conflict Variable @1 conflicts with parameter in same procedure -901 335544666 srvr_version_too_old Server version too old to support all CREATE DATABASE options -901 335544673 no_delete Cannot delete -901

Linux distributions put it in /etc/firebird/n.n where n.n is the version of the Firebird database server. There is more information on connecting to databases, using full paths or aliases, below. Chapter -x extract metadata -z show program and server version Not all of these switches appear in every release of Firebird. Some will be seen in more Command Line Switches 7 When the server provides line and column information, users can see the exact line of the DML in the script that caused the problem. When the server only indicates failure, users

[ [ ...]] [DIFFERENCE FILE 'diff_file']; ::= [<server_spec>]{filepath | db_alias} <server_spec> ::= host[\port | service]: | \\host[@port | service]\ | ://[host[:port Описание filespec Спецификация первичного файла базы данных. Операторы DDL 89 Параметр Описание server_spec Спецификация удалённого сервера. Включает в себя имя сервера и протокол. Необходима, если база use Имя соединения уже используется 8003 Connection does not exist Соединение не существует 8004 Server rejected the connection Сервер отверг подключение 8006 Connection failure Ошибка при подключении

in comparison to the data manipulation language (DML) employed for queries and the PSQL used for server-based programming. The leader of the Firebird Project’s documentation team, Paul Vinkenoog, took data type, available only in Dialect 3. If a client uses Dialect 1, the generator value sent by the server is reduced to a 32-bit integer (INTEGER). When Dialect 3 is used for connection, the generator value are automatically re-encoded, both when data are sent from the client to the server and when they are sent back from the server to the client. For example, if the database was created in the WIN1251 encoding