port number or service name. Required if the database is created on a remote server. filepath Full path and file name including its extension. The file name must be specified according to the rules of specification for a secondary file pagenum Starting page number for a secondary database file diff_file File path and name for DIFFERENCE files (.delta files) for backup mode The CREATE DATABASE statement creates The primary file specification is the name of the database file and its extension with the full path to it according to the rules of the OS platform file system being used. The database file must not

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44 18.8. SET EXEC_DISPLAY_PATH . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 18.15.1. Effects of Various Plan-Related Commands . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . you are advised to run the Firebird utility from its own directory, or provide the absolute file path if you have another relational database, besides Firebird, installed on your machine.  Some affected

Firebird user name -V[ERIFY] report each action taken -Y <path> redirect/suppress status message output -Z print version number Firebird user name -V(ERIFY) report each action taken -Y <path> redirect/suppress status message output -Z print version number database via the service manager. This causes the backup file to be created on the remote server, so the path format and filename must be valid on Chapter 2. Command-line Options 8 the remote server. The servicename

Multidatabase transaction: Host Site: linux Transaction 67 has been prepared. Remote Site: remote Database path: /opt/firebird/examples/testlimbo.fdb If the command is run against the remote database then nothing Multidatabase transaction: Host Site: linux Transaction 67 has been prepared. Remote Site: remote Database path: /opt/firebird/examples/testlimbo.fdb Commit, rollback or neither (c, r, or n)? 6.2. Committing Or sweep through the database and remove the remnants of rolled back transactions and this has two effects: • The space recovered is made available for reuse by the same table, however, if this results in

for %FIREBIRD% it will make that path the default location that it offers, instead of c:\Program Files\Firebird\Firebird_2_1 . Unless you are very clear about the effects of having a wrong value in this under this key always exists. It will be known as "DefaultInstance" and will store the path to the root directory of the default installation. Those who don't care about particular installations location, browse to a location you have pre-created; or just type in the full path and let the installer find it. The path you type in doesn't have to exist: the installer will prompt you and create it

TCP/IP or Windows Networking style. Optionally includes a port number or service name filepath Full path and file name including its extension. The file name must be specified according to the rules of specificaton for a secondary file pagenum Starting page number for a secondary database file diff_file File path and name for DIFFERENCE files (.delta files) The CREATE DATABASE statement creates a new database The primary file specification is the name of the database file and its extension with the full path to it according to the rules of the OS platform file system being used. The database file must not

Adventures add id icnn; For the presence of NULLs in the added columns, returning of false 0's, effects of default values etc., it makes no difference at all whether you take the domain route or the direct

database from Firebird 3 and higher 1. Backup your security3.fdb or security4.fdb gbak -user sysdba -b {path}security4.fdb security4.fbk # or using the security.db alias gbak -user sysdba -b security.db securitydb Restore the backup of the first step as the security database gbak -user sysdba -c security4.fbk {path}security5.fdb # or using the security.db alias gbak -user sysdba -c securitydb.fbk security.db Contrary refers to the Windows programs folder. This is usually “C:\Program Files” but may also be a different path, e.g. “D:\Programmi”. Likewise, %windir% refers to the Windows directory. Be sure to read the notes

refers to the Windows programs folder. This is usually “C:\Program Files” but may also be a different path, e.g. “D:\Programmi”. Likewise, refers to the Win- dows system directory. Be sure to read an optional copy in – see note below table) The Windows system directory The exact path to the Windows System directory depends on your Windows version. Typical locations on 32- bit systems “tricking” gsec into using TCP/IP. Add the following parameter to the command line, adjusting the path if necessary: -database "localhost:C:\Program Files\Firebird\Firebird_2_0\security2.fdb" Firebird

.............................................................................. 13 Server name and path ............................................................................................... 13 the real stuff is in / lib, but you should use the links in /usr/ lib) Note The exact path to the Windows System directory depends on your Windows version. Typical loca- tions are: • for Windows problem in the Release Notes (look in the doc subdir of your Firebird installation). Server name and path If you move the sample database, be sure you move it to a hard disk that is physically attached to