CreateInternalWindow in firebird.conf is now deprecated. You no longer need to disable it if you need to run multiple instances of Firebird simultaneously. Change to API DPB Parameters in V.2.1.2 and V.2.0.5: FROM RDB$DATABASE) FROM RDB$RELATIONS b) 2. Ambiguity checking in subqueries This would run on Firebird 1.5 without reporting an ambiguity, but will report it in Firebird 2.0: SELECT (SELECT " outside the scope of the cursor loop was accepted by the PSQL parser, allowing the likelihood of run-time occurring as a result. Now, it will be rejected in the procedure or trigger definition. NULLS

utility to display the database details with the command line: gstat -header db_name however, to run gstat, you need to be logged into the server — it cannot be used remotely. linux> gstat -header my_employee limbo transactions is shown below. This command is run against the local database on the server named linux where a multi-database transaction had been run connected to databases linux@my_employee and remote:testlimbo prepared. Remote Site: remote Database path: /opt/firebird/examples/testlimbo.fdb If the command is run against the remote database then nothing will be listed because that database does not have any limbo

prevent this, set the CpuAffinityMask parameter in the configuration file firebird.conf. Guardian When run as a Windows application (as opposed to a service) you can't use the Fire- bird Guardian. Note that application is the only option on Win- dows 9x–ME. Can be used with the Guardian on Win- dows, whether run as an application or as a service. Events Can't use Fiebird events if the server is be- hind a firewall or a network filesystem. Note You can mount a read-only database on a CD-ROM drive but you cannot run Firebird server from one. Installation script or program Although it is possible to install Firebird

about the version of gbak being used, and optionally, a database. To obtain the version of gbak only, run the command as follows: tux> gbak -z gbak:gbak version LI-V2.5.0.26074 Firebird 2.5 gbak: ERROR:requires -N[O_VALIDITY] do not restore database validity conditions -NOD[BTRIGGERS] do not run database triggers Chapter 2. Command-line Options 5 -NT Non-Transportable checksums -L(IMBO) ignore transactions in limbo -NOD(BTRIGGERS) do not run database triggers -NT Non-Transportable backup file format -OL(D_DESCRIPTIONS)

your Firebird version matches this guide. This guide covers versions 1.0, 1.0.2 and 1. 0.3. If you run Firebird 1.5 or higher, get the appropriate version of the Quick Start Guide at http://www.firebirdsql less safe. Server must run as root. This poses a risk if the server were to be hacked or contained a severe bug. (Note: in Firebird 1.5 this is no longer the case.) Server can run as non-root user, e.g and resource links as InterBase 6.x and prior versions of InterBase. Hence, it is not possible to run both a Firebird server and an In- terBase server on the same machine with these versions - at least

covered here.)  You can open a read-only database from a read-only medium like a DVD, but you cannot run Firebird server from one. 3.2.3. Installation script or program Although it is possible to install for privilege elevation when run. On Windows Server platforms Firebird will run as a system service by default, but during installation you can also choose to let it run as an application. Don’t do this this unless you have a Chapter 3. Installing Firebird 7 compelling reason. If you do want to run Firebird as an application, it is recommended to install it outside the Program Files folder to ensure

on behalf of the users.  It is possible on some operating systems that users will not be able to run gsec, even if they know the SYSDBA password. This is because those operating systems allow the system as a privileged user. Like most of the command line utilities supplied with Firebird, gsec can be run in interactive or batch mode and has a help screen showing all of the utility’s options, we’ll be Chapter 1. Introduction 3 Chapter 2. Command Line Options Regardless of the mode that gsec is run in, there are a number of options that can be supplied on the command line. These are: -user

one column from not more than one matching row or aggregation. If the result would return more, a run-time error will occur (“Multiple rows in a singleton select…”).  Although it is reporting a genuine specified metadata changes events in a specified phase. BEFORE triggers run before changes to system tables. AFTER triggers run after changes in system tables.  The event type [BEFORE | AFTER] of a do the changes in an AUTONOMOUS TRANSACTION, so if an exception happens -- and the command didn't run, the log will survive. in autonomous transaction do begin insert into ddl_log (id, moment,

provided here will not allow InterBase and Firebird to run at the same time. You can toggle between them with a minimum of hassle though. Note In order to run InterBase and Firebird 1.5 really simultaneously and you'll be linked back here later. b. Install Firebird 1.5 using the installation program (i.e. run the downloaded .exe file). On the setup screen titled “Select Additional Tasks”, make sure the box completed the setup steps, you can start up InterBase and Firebird at will; just take care they don't run at the same time. There are several ways to start and stop the database servers: • Easiest, most powerful

in the Linux environment, for example, MySQL, also use isql as a utility name, you are advised to run the Firebird utility from its own directory, or provide the absolute file path if you have another -n(oautocommit) no autocommit DDL (set autoddl off) -nod(btriggers) do not run database triggers -now(arnings) do not show warnings -o(utput) extract DDL statements, such as -a and -x also only initiate a non-interactive session. Isql can be run from either a local or remote client: • When connecting using a local client, you may set the environment