. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 17. Isql Commands . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 18. Isql Set Commands . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 18.15.1. Effects of Various Plan-Related Commands . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49 18.16. SET PLANONLY

maximum, no special characters except the underscore ‘_’ (unless you use quoted identifiers). The SQL commands and statements that apply to generators are listed below. Their use will be discussed in some detail the only option in Firebird 2.  In Firebird’s command-line tool isql there are two additional commands for retrieving current generator values: SHOW GENERATOR GeneratorName; SHOW GENERATORS; The first Chapter 3. SQL statements for generators 8 SHOW SEQUENCES; Please notice again that these SHOW … commands are only available in the Firebird isql tool. Unlike GEN_ID, you can’t use them from within other

in another document. In this manual, we will discuss: • Command-line options for gbak. • gbak commands and their parameters. • Running gbak in backup or restore modes. • Some caveats, gotchas and foibles will be named as per the second file name supplied on the command line.  You may, if you wish, send the output to standard output rather than a backup file. In this case, you must specify stdout as to the standard input of another, is how you can avoid creating an intermediate dump file. The commands above assume that there are suitable alias names set up for both emptest and emptest_2. If not

you have started an InterBase version up to 5.6 via the Guardian, you must give two net stop... commands to take it down: first for the Guardian, then for the server. With InterBase 6.0 and Firebird, stopping please let us know! This document is part of the Firebird manual module so the most logical place to send comments to is the firebird-docs mailing list, to which you can subscribe here: http://lists.sourceforge

As a regular client application, its native language is DSQL. It also offers a few additional commands that are not available outside its specific environment. Both DSQL and PSQL subsets are completely 1 or higher), RDB$VALID_BLR is NULL. This does not imply that their BLR is invalid. • The isql commands SHOW PROCEDURES and SHOW TRIGGERS display an asterisk in the RDB$VALID_BLR column for any module 336330799 gbak_cant_rest_record warning — record could not be restored -901 336330800 gbak_send_failed Gds_$send failed -901 335544369 segstr_no_read Attempted read of a new, open BLOB -901 336330801 gbak_no_tbl_name

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 3. Gsec Commands . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . remainder of this manual we shall discuss the following: • Command line options for gsec. • Gsec commands and their parameters. Chapter 1. Introduction 2 • Running gsec in interactive or batch modes -trusted (use trusted authentication) -database -z available commands: adding a new user: add [ ... ] deleting a current user:

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 3. Gfix Commands. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . to their databases. Almost all the gfix commands have the same format when typed on the command line: gfix [commands and parameters] database_name The commands and their options are described in the following abbreviated to the unparenthesized characters Chapter 2. Command Line Options 4 Chapter 3. Gfix Commands  In the following discussion, I use the full parameter names in all examples. This is not necessary

/usr/lib64 if both server and client are 64-bits). 2. Create chained symlinks using the following commands: ln -s /usr/lib/libfbclient.so.5.0.n /usr/lib/libfbclient.so.2 ln -s /usr/lib/libfbclient.so.2 databases. 5.1. User management Since Firebird 3, user management is done entirely through SQL commands. Users of previous versions are probably familiar with the gsec utility for this task. It is still follows: create user billyboy password 'TooLongFor8099Comfort'; The full range of user management commands is: CREATE USER username [ ...] [TAGS ( [,

As a regular client application, its native language is DSQL. It also offers a few additional commands that are not available outside its specific environment. Both DSQL and PSQL subsets are completely affect existing data or columns. The new default character set will only be used in subsequent DDL commands. ENCRYPT WITH See Encrypting a Database in the Security chapter. DECRYPT See Decrypting a Database Firebird for replication is not covered in this language reference. • All replication management commands are DDL statements and thus effectively executed at the transaction commit time. Examples of ALTER

is installed. Copy it to /usr/lib on the client. 2. Create chained symlinks using the following commands: ln -s /usr/lib/libfbclient.so.2.m.n /usr/lib/libfbclient.so.2 ln -s /usr/lib/libfbclient.so.2 + path/alias as a single connection string – just like isql does. • Remember that file names and commands on Linux and other “Unix-ish” platforms are case-sensitive. Creating a database using isql There