Firebird Documentation IndexIsql - Interactive SQL → Starting An Isql Session
Firebird Home Firebird Home Prev: Invoking IsqlFirebird Documentation IndexUp: Isql - Interactive SQLNext: Connecting To A Database

Starting An Isql Session

To begin an isql session, enter the command line options and the name of the database in the Linux /Unix shell or Windows command console. For example:

isql [options] [database_name_or_alias]

Note

When invoking isql, you will need to include an appropriate -user and -password in your options, unless users have the ISC_USER and ISC_PASSWORD declared as operating system variables. For example:

isql -user SYSDBA -password masterkey

Isql starts an interactive session if no options are specified. If no database is specified, users must connect to an existing database or create a new one after starting isql. It starts the interactive session by connecting to the named database, provided the login options are accurate and valid for the specified database. Depending on the options specified, isql starts an interactive or non-interactive session.

Reading an input file and writing to an output file are not considered interactive tasks, therefore the -input or -output command line options do not initiate an interactive session. Options used to extract DDL statements, such as -a and -x also only initiate a non-interactive session.

Isql can be run from either a local or remote client:

Prev: Invoking IsqlFirebird Documentation IndexUp: Isql - Interactive SQLNext: Connecting To A Database
Firebird Documentation IndexIsql - Interactive SQL → Starting An Isql Session