. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 3. Invoking Isql. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 5. Starting An Isql Session . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 6. Ending an Isql Session . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 13. Isql Prompts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Работа с базами данных ..... 16 Подключаемся к базе данных ..... 16 Создаем базу данных с помощью isql ..... 18 Firebird SQL ..... 19 Безопасность и надежность ..... 22 Безопасность ..... 22 Резервируем использованием пароля masterkey. ## Используем isql Существует несколько способов подключения к базе данных с использованием утилиты isql. Один из них - это использование isql в интерактивном режиме. Перейдите в версия Firebird, и в командной строке наберите isql (для Linux: ./isql) [☐ означает «нажать клавишу Enter»]: C:\Program Files\Firebird\Firebird_1_5\bin>isql Use CONNECT or CREATE DATABASE to specify a

Server name and path ..... 13 The CONNECT statement ..... 14 Creating a database using isql ..... 15 Starting isql ..... 15 The CREATE DATABASE statement ..... 15 Performing a client-only install as SYSDBA using the password masterkey. ## Using isql There are several different ways to connect to a database using isql. One way is to start isql in its interactive shell. Go to the bin subdirectory Firebird installation and, at that prompt, type the command isql (on Linux: ./isql) [\# means "hit Enter":] C:\Program Files\Firebird\bin>isql# Use CONNECT or CREATE DATABASE to specify a database

database ..... 32 6.2.1. Connecting with isql ..... 32 6.2.2. Connecting with a GUI client ..... 33 6.3. Creating a database using isql ..... 33 6.3.1. Starting isql ..... 34 6.3.2. The CREATE DATABASE way of testing the server after installation is by starting a Firebird client (e.g./opt/firebird/bin/isql) and connecting to a database or creating one. These operations are described later in this guide the API routines can locate the messages. 4. Optionally copy the Firebird command-line tools — e.g. isql — to the client machine as needed. Instead of copying the files from a server, you can also pull

strings ..... 20 Connecting to an existing database ..... 22 Creating a database using isql ..... 23 Firebird SQL ..... 24 Protecting your data ..... 28 Backup ..... 28 How to |Firebird server|fbserver (SS) or fb\_inet\_server (CS)|<installDir>/bin| |Command-line tools|isql, gbak, nbackup, gsec, gfix, gstat, etc.|<installDir>/bin| |Sample database|employee.fdb|< server|fbserver.exe (SS) or fb\_inet\_server.exe (CS)|<InstallDir>\\bin| |Command-line tools|isql.exe, gbak.exe, nback-up.exe, gsec.exe, gfix.exe, gstat.exe, etc.|<InstallDir>\\bin| |Sample

et chemin ..... 15 La commande CONNECT ..... 15 Créer une base de données avec isql ..... 17 Démarrage de isql ..... 17 L'instruction CREATE DATABASE ..... 17 Effectuer une installation client-seulement mot de passe masterkey. ## Utiliser isql Il y a plusieurs manières de se connecter à une base de données en utilisant isql. Une de ces manières est de démarrer isql en mode interactif. Allez dans le sous-répertoire l'invite de commande, tapez la commande isql (sous Linux: ./isql) [\# signifie « appuyez sur la touche Enter »]: C:\Program Files\Firebird\Firebird_1_5\bin>isql# Use CONNECT or CREATE DATABASE to specify

ruta de acceso ..... 14 La sentencia CONNECT ..... 15 Crear una base de datos usando isql ..... 16 Arrancar isql ..... 16 La sentencia CREATE DATABASE ..... 16 Realizar una instalación de cliente SYSDBA usando la clave masterkey. ## Usando isql Hay varias formas diferentes para conectar con una base de datos usando isql. Una forma es ejecutar isql en su terminal interactiva. Diríjase al subdirectorio de su instalación y en el prompt tipee el comando isql (nota: # significa “presione Enter ”): C:\Archivos de programa\Firebird\Firebird_1_5\bin>isql# Use CONNECT or CREATE DATABASE to specify a database

Verbindungsstrings ..... 19 Verbinden zu einer existierenden Datenbank ..... 21 Eine Datenbank mit isql erstellen ..... 23 Firebird SQL ..... 24 Vermeidung von Datenverlust ..... 28 Sicherung ... >(CS)Kommandozeilentoolsisql.exe,gbak.exe, nbbackup.exe, gsec.exe, gfix.exe, gstat.exe, etc.<installdir>\bin<installdir>/binKommandozeilentoolsisql, gbak, nbbackup, gsec, gfix, gstat, usw.<installdir>/binBeispiel

shadow file already exists for the database. To this end, a shadow was created as follows: linux> isql my_employee; SQL> create shadow 1 manual '/home/norman/firebird/shadow/my_employee.shd1'; session is connected to the database and can see that there are two shadow files attached: linux_1>isql my_employee Database: my_employee SQL> show database; Database: my_employee Owner: SYSDBA Shadow connect to the database. linux_2> rm /home/norman/firebird/shadow/my_employee.shd2 linux_2> isql_my_employee Statement failed, SQLCODE = -901 lock conflict on no wait transaction -I/O error for

that for you as the following example shows. tux> # Check current shadows, use isql as gstat is broken. tux> isql employee Database: employee SQL> show database; Database: employee Owner: SYSDBA -replace overwrite /backups/employee.fbk employee tux> # Check shadows again, use isql as gstat is broken. tux> isql employee Database: employee SQL> show database; Database: employee Owner: SYSDBA overwrite -kill /backups/employee.fbk employee tux> # Check shadows again, use isql as gstat is broken. tux> isql employee Database: employee SQL> show database; Database: employee Owner: SYSDBA