dbishell(1)

NAME

dbishell - a generic database shell based on the perl DBI

layer

SYNOPSIS

dbishell [ --driver drivername   ]
         [ --dsn dsn_name        ]
         [ --user username       ]
         [ --pass password       ]
         [ --shell-driver Driver ]
         [ --dotdir directory    ]

DESCRIPTION

Arrayshell such as sqlplus or mysql, but in a database independant manner. In some cases, it will be significantly more advanced
than the command line database shell supplied by your database
vendor.

OPTIONS

--driver

Arraymysql
Oracle
Sybase
ODBC
Pg

--dsn

ArrayIf a dsn is not supplied, dbishell will ask for one.

--user

ArrayIf a username is not supplied, dbishell will ask for one.

--pass

Arraypassword is supplied, one will be asked for.
--shell-driver

ArrayDBD::ODBC driver, or are using the Sybase driver to connect to an
MS SQL database] then you may specify the name of the dbishell
driver here. Not used often.
--dotdir

The path to the directory where dbishell should look for

its dotfiles.

USAGE

Line termination:

ArrayThis character was chosen for compatability with Oracle reasons,
but can be configured.
Tab completion:

Arraywhere this provides insufficient information, dbishell falls back
to 'dumb' completion.
Variables:

ArraySetting Variables:

Arrayinterpolated before setting the LHS.
String Interpolation:

Arraytation, thus the database will be unaware that a variable was
even used.
Bound Parameters:

Arraythat your database [or at least your DBD driver] must support
bound parameters for this to work, and not all parts of a query
can have parameters bound into them.
Special Variables:

There are 2 special categories of variables:

Environment Variables:

Arrayof, over and above any imposed by the environment itself.
DBI Connection Parameters:

Arrayprobably shouldn't use them for anything else, such as bound parameters.
Other Important Variables:

Arraythen '/' is used. [except that the '/' that terminates a comment
will be ignored]. Otherwise, whatever you put in $EOL will be
scanned for.
Commands:

Arrayhelp

help TOPIC

Arraydescribe

describe THING

Arrayprocedures etc...
read

read FILEPATH

Arrayinterpolation

interpolation on|off

Turn on or off variable interpolation.

escaping

escaping on|off

Turn on or off backslash escape interpretation.

show

show tables|views|THING|etc...

Arraydbishell from within itself this way.
cd

Change the working directory.

spool

Arraylicense

license

Display the license.

quit

quit

EXAMPLES

Array--user sa

SEE ALSO

The README file in the DBIShell distribution.

AUTHOR

ArrayDBISHELL(1)