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

.. 15 Crear una base de datos usando isql ...................................................................................................... 16 Arrancar isql ..................................... como 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

recently.  Because of the inconsistency between what gstat reports and reality, it is best to use isql and the SHOW DATABASE command to view correct details of the shadow files. Page buffers If this table’s id is actually the column RDB$RELATION_ID in the system table RDB$RELATIONS, as the following isql session shows: SQL> select rdb$relation_name CON> from rdb$relations CON> where rdb$relation_id = duplicates and these statistics report on the number of duplicates the index holds. The following isql query shows the details of duplicates for an indexed column in a different table to the one being

implementation are: • Dynamic SQL (DSQL) • Procedural SQL (PSQL) • Embedded SQL (ESQL) • Interactive SQL (ISQL) Dynamic SQL is the major part of the language which corresponds to Part 2 (SQL/Foundation) of the expressions implemented in DSQL are supported in ESQL. Interactive ISQL refers to the language that can be executed using Firebird isql, the command-line application for accessing databases interactively environment. Both DSQL and PSQL subsets are completely presented in this reference. Neither ESQL nor ISQL flavours are described here unless mentioned explicitly. 2.1.2. SQL Dialects SQL dialect is a term