Firebird Documentation IndexIsql - Interactive SQL → Command Line Switches
Firebird Home Firebird Home Prev: Invoking IsqlFirebird Documentation IndexUp: Isql - Interactive SQLNext: Starting An Isql Session

Command Line Switches

Command line switches are arguments that begin with a minus/hyphen (-) character. The following is an example of what happens when you attempt to start isql with an invalid switch - it displayes the list of valid switches with a brief explanation of each.

tux> $ isql --help

Unknown switch: -help
usage:    isql [options] [<database>]
        -a(ll)                  extract metadata incl. legacy non-SQL tables
        -b(ail)                 bail on errors (set bail on)
        -c(ache) <num>          number of cache buffers
        -ch(arset) <charset>    connection charset (set names)
        -d(atabase) <database>  database name to put in script creation
        -f(etch_password)       fetch password from file
        -e(cho)                 echo commands (set echo on)
        -ex(tract)              extract metadata
        -i(nput) <file>         input file (set input)
        -m(erge)                merge standard error
        -m2                     merge diagnostic
        -n(oautocommit)         no autocommit DDL (set autoddl off)
        -nod(btriggers)         do not run database triggers
        -now(arnings)           do not show warnings
        -o(utput) <file>        output file (set output)
        -pag(elength) <size>    page length
        -p(assword) <password>  connection password
        -q(uiet)                do not show the message "Use CONNECT..."
        -r(ole) <role>          role name
        -r2 <role>              role (uses quoted identifier)
        -s(qldialect) <dialect> SQL dialect (set sql dialect)
        -t(erminator) <term>    command terminator (set term)
        -u(ser) <user>          user name
        -x                      extract metadata
        -z                      show program and server version

Not all of these switches appear in every release of Firebird. Some will be seen in more recent releases. Many of the switches have an equivalent set command, and these will be discussed below.

Prev: Invoking IsqlFirebird Documentation IndexUp: Isql - Interactive SQLNext: Starting An Isql Session
Firebird Documentation IndexIsql - Interactive SQL → Command Line Switches