Man Linux: Main Page and Category List

NAME

       isql -- Firebird Interactive SQL shell

SYNOPSIS

       isql  [  -a  ]  [ -cache bufnum ]  [ -database database ]  [ -echo ]  [
       -input infile ]  [ -noautocommit ]  [ -nowarnings ]  [ -output  outfile
       ]   [  -password  password  ]   [ -page pagelen ]  [ -role role ]  [ -s
       sqldialect ]  [ -terminator lineterm ]  [ -user user ]  [ -x ]  [ -z ]

DESCRIPTION

       This manual page documents briefly the isql command.

       This manual page was written for the Debian  distribution  because  the
       original  program  does not have a (free) manual page.  Instead, it has
       non-free documentation you can get from InterBase (Borland) or FireBird
       project sites; see at the end of the document.

       isql  is a program that allows the user to issue arbitrary SQL commands
       to a Firebird database as well as exctacting the metadata.

       isql in Debian is available under isql-fb name due to filename conflict
       with  binary  from  other  package.  If for some reason it is needed to
       have it under original name it is possible to add /usr/lib/firebird/bin
       at  the beginning of PATH variable which should solve eventual problem.

OPTIONS

       isql can handle various command line  options.   Most  options  can  be
       abbreviated.  Below are given the shortest abbreviations as well as the
       full versions.  A summary of options follows.

       -a
                 Extract DDL  statements  necessary  to  re-create  database's
                 metadata.   The CREATE DATABASE statement is surrounded by C-
                 style comment.  Statements are  printed  to  standard  output
                 unless redirection is used. See -output. See -x.

       -c[ache] buffers
                 Specify  default  number  of  cache  buffers  to  be  used in
                 connections.

       -d[atabase] database
                 Used together with -x. Specifies target  database  name  when
                 extracting. See -x.

       -e[cho]   Display each statement before executing it.

       -x|-ex[tract]
                 Extracts  DDL  statements to recreate database metadata.  The
                 only difference with -a is that -extract behaves  differently
                 if -d is also specified.

                 If  no  -d  is  specified, -x behaves exactly as -a. If -d is
                 specified, the  CREATE  DATABASE  statement  is  uncommented,
                 replacing database name with database.

       -i[nput] infile
                 Reads  commands  from infile instead of standard input. Exits
                 with commit after the last command.

       -m[erge_stderr]
                 Merges  standard  error  to  standard  output.   Useful   for
                 redirecting both streams.

       -n[oautocommit]
                 Normally,   all   DDL   statements   like  CREATE  TABLE  are
                 automatically  committed  in  a  separate  transaction.  This
                 option disables the automatic commit of DDL statements.

       -nowarnings
                 Disables displaying of SQL warnings.

       -o[utput] outfile
                 All output is redirected to the given outfile.

       -page[length] n
                 Prints column headers every n output lines. Default is 20.

       -pas[sword] password
                 Uses  given  password  as  a  default  for  connecting to the
                 database.

       -r[ole] sqlrole
                 Uses given  sqlrole  as  a  default  for  connecting  to  the
                 database.

       -s[qldialect] sqldialect
                 Uses  given  sqldialect  as  a  default for connecting to the
                 database.

       -t[erminator] lineterm
                 Set command line terminator. Default is semicolon (`;').

        -u[ser] username
                 Uses given username  as  a  default  for  connecting  to  the
                 database.

       -z        Show version string before doing anything else.

SEE ALSO

       gbak(1), gdef(1), gfix(1),  gpre(1), gsec(1),  gstat(1), qli(1).

       Additional  documentation  about  isql  and other Firebird parts can be
       found on the Firebird Project website.

       For    more    information    about     Firebird     project,     visit
       http://www.firebirdsql.org/.

AUTHOR

       This  manual page was written by Damyan Ivanov (dam@modsoftsys.com) for
       the Debian system (but may be used by others). Permission is granted to
       use  this  document,  with or without modifications, provided that this
       notice is retained. If we meet some day, and you think  this  stuff  is
       worth it, you can buy me a beer in return.

                                                                       ISQL(1)