-fe(tch_password) fetch password from file -h(ousekeeping) set sweep interval -i(gnore) ignore checksum errors -icu fix database to be usable with present -nol(inger) close database ignoring linger setting for it -n(o_update) read-only validation (-v) -o(nline) database online -pr(ompt) force garbage collection -sh(utdown) shutdown -tw(o_phase) perform automated two-phase recovery -tra(nsaction) shutdown transaction startup

-FA[CTOR] blocking factor -G[ARBAGE_COLLECT) inhibit garbage collection -I[NACTIVE] deactivate indexes during restore -IG[NORE] ignore bad checksums backup metadata only -MO[DE] "read_only" or "read_write" access -N[O_VALIDITY] do not restore database validity conditions -NOD[BTRIGGERS] do not run Command-line Options 5 -NT Non-Transportable backup file format -O[NE_AT_A_TIME] restore one table at a time -OL[D_DESCRIPTIONS] save old style metadata

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 4.5. Direkte I/O (Firebird 2.1.4+) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . an (mit -L) 2.1 -T Datenbanktrigger unterdrücken (mit -B, -L, -N) 2.1 -D {on | off} Direkte I/O an/aus (mit -B) 2.1.4 -U username Geben Sie den Benutzernamen an (mit -B, -L, -N) -P password Passwort Datenbanken unter Posix handelt, kann auch die Verwendung von direkter I/O einen Unterschied machen. Mehr dazu im Abschnitt Direkter I/O. 4.1. Vollständige Sicherungen 4.1.1. Vollständige Sicherung erstellen

| D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z ::= a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | VARCHAR(15)) RETURNS ( LANGUAGES VARCHAR(15)) AS DECLARE VARIABLE I INTEGER; BEGIN I = 1; WHILE (I <= 5) DO BEGIN SELECT LANGUAGE_REQ[:I] FROM JOB WHERE (JOB_CODE = :CODE) AND (JOB_GRADE (:LANGUAGES = '') THEN /* PRINTS 'NULL' INSTEAD OF BLANKS */ LANGUAGES = 'NULL'; I = I +1; SUSPEND; END END Если приведённых выше возможностей достаточно для ваших задач

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 773 Appendix I: Document History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z ::= a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q their definition or declaration. Thus, "FullName" (quoted) is different from FullName (unquoted, i.e. regular) which is stored as FULLNAME in the metadata. 2.4. Literals Literals are used to directly

Руководство по языку SQL cot dow dpower floor getExactTimestamp i64round i64truncate ln log log10 lower lpad ltrim mod *nullif *nvl pi rand right round, i64round rpad rtrim sdow sign sin sinh sqrt srand sright sright string2blob strlen substr substrlen tan tanh truncate, i64truncate Приложение А: Примечания Набор символов NONE воспринимается «как есть» (“as is”) Понимание предложения WITH LOCK Синтаксис и поведение данных вместо целого. Примеры: SELECT NAMEBLOB FROM MYTABLE WHERE NAMEBLOB COLLATE PT_BR = 'Joậo' CREATE TABLE MYPICTURES ( ); ID INTEGER NOT NULL PRIMARY KEY, TITLE VARCHAR(40), DESCRIPTION VARCHAR(200)

G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z ::= a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q their definition or declaration. Thus, "FullName" (quoted) is different from FullName (unquoted, i.e., regular) which is stored as FULLNAME in the metadata. 2.4. Literals Literals are used to represent Starting from Firebird 2.0, the maximum length for an index equals one quarter of the page size, i.e. from 1,024 — for page size 4,096 — to 4,096 bytes — for page size 16,384. The maximum length of

-ex(tract) extract metadata -f(etch_password) fetch password from file -i(nput) input file (set input) -m(erge) merge standard error do not run database triggers -now(arnings) do not show warnings -o(utput) output file (set output) -pag(elength) page length -p(assword) -ex(tract) can be used to extract meta data from the database. It can be used in conjunction with the -o(utput) switch to extract the information to a specified output file. The resultant information can

prepare a CREATE DATABASE/SCHEMA statement -532 335544469 trans_invalid Transaction marked invalid by I/O error -551 335544352 no_priv No permission for %s access to %s %s -551 335544790 insufficient_svc_privileges RDB$COLLATIONS -901 336330972 gbak_read_error Unexpected I/O error while reading from backup file -901 336330973 gbak_write_error Unexpected I/O error while writing to backup file -901 336330985 gbak_db_in_use floating-point operation is less than the magnitude allowed. -901 335544778 exception_integer_divide_by_zer o Integer divide by zero.The code attempted to divide an integer value by an integer divisor of zero

...................................................................................... 3 ¿Classic o Superserver? ...................................................................................... ....................................................................................... 7 Programa o script de instalación ............................................................................. coincide con esta guía. Esta guía cubre las versiones 1.5 y superiores. Si Ud. tiene Firebird 1.0, 1.02 o 1.03, obtenga la versión apropiada de la Guía de Arranque Rápido en http://www.firebirdsql.org/index