.TH "ISQL" "1" 
.SH "NAME" 
isql \(em Firebird Interactive SQL shell 
.SH "SYNOPSIS" 
.PP 
\fBisql\fR [ \-a ]  [ \-cache \fIbufnum\fR ]  [ \-database \fIdatabase\fR ]  [ \-echo ]  [ \-input \fIinfile\fR ]  [ \-noautocommit ]  [ \-nowarnings ]  [ \-output \fIoutfile\fR ]  [ \-password \fIpassword\fR ]  [ \-page \fIpagelen\fR ]  [ \-role \fIrole\fR ]  [ \-s \fIsqldialect\fR ]  [ \-terminator \fIlineterm\fR ]  [ \-user \fIuser\fR ]  [ \-x ]  [ \-z ]  
.SH "DESCRIPTION" 
.PP 
This manual page documents briefly the 
\fBisql\fR command. 
.PP 
This manual page was written for the \fBDebian\fP 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. 
.PP 
\fBisql\fR is a program that 
allows the user to issue arbitrary SQL commands to a Firebird database 
as well as exctacting the metadata. 
.PP 
\fBisql\fR in \fBDebian\fP is available under 
\fBisql-fb\fR 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. 
.SH "OPTIONS" 
.PP 
\fBisql\fR 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. 
.IP "\fB-a\fP 		" 10 
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 \fB-output\fP. See \fB-x\fP. 
.IP "\fB-c[ache] \fIbuffers\fR\fP 		" 10 
Specify default number of cache buffers to be used in connections. 
.IP "\fB-d[atabase] \fIdatabase\fR\fP 		" 10 
Used together with \fB-x\fP. Specifies target database name when extracting. See \fB-x\fP. 
.IP "\fB-e[cho]\fP         " 10 
Display each statement before executing it. 
.IP "\fB-x|\-ex[tract]\fP 		" 10 
Extracts DDL statements to recreate database metadata. 
The only difference with \fB-a\fP is that \-extract 
behaves differently if \fB-d\fP is also specified. 
.IP "" 10 
If no \fB-d\fP is specified, \-x behaves exactly 
as \fB-a\fP. If \fB-d\fP is specified, 
the CREATE DATABASE statement is uncommented, replacing database 
name with \fIdatabase\fR. 
.IP "\fB-i[nput] \fIinfile\fR\fP         " 10 
Reads commands from \fIinfile\fR instead of standard input. Exits with commit after the last command. 
.IP "\fB-m[erge_stderr]\fP 		" 10 
Merges standard error to standard output. Useful for redirecting both streams. 
.IP "\fB-n[oautocommit]\fP" 10 
Normally, all DDL statements like CREATE TABLE are 
automatically committed in a separate transaction. This option 
disables the automatic commit of DDL statements. 
.IP "\fB-nowarnings\fP" 10 
Disables displaying of SQL warnings. 
.IP "\fB-o[utput] \fIoutfile\fR\fP 		" 10 
All output is redirected to the given \fIoutfile\fR. 
.IP "\fB-page[length] \fIn\fR\fP 		" 10 
Prints column headers every 
\fIn\fR output lines. Default is 20. 
.IP "\fB-pas[sword] \fIpassword\fR\fP 		" 10 
Uses given \fIpassword\fR as a default 
for connecting to the database. 
.IP "\fB-r[ole] \fIsqlrole\fR\fP 		" 10 
Uses given \fIsqlrole\fR as a default 
for connecting to the database. 
.IP "\fB-s[qldialect] \fIsqldialect\fR\fP 		" 10 
Uses given \fIsqldialect\fR as a default 
for connecting to the database. 
.IP "\fB-t[erminator] \fIlineterm\fR\fP         " 10 
Set command line terminator. Default is semicolon (`;'). 
.IP "\fB \-u[ser] \fIusername\fR\fP 		" 10 
Uses given \fIusername\fR as a default 
for connecting to the database. 
.IP "\fB-z\fP         " 10 
Show version string before doing anything else. 
.SH "SEE ALSO" 
.PP 
gbak(1), gdef(1), gfix(1),  gpre(1), gsec(1),  gstat(1), qli(1). 
.PP 
Additional documentation about \fBisql\fR and 
other \fBFirebird\fP parts can be found on the Firebird Project website. 
.PP 
For more information about Firebird project, visit 
http://www.firebirdsql.org/. 
.SH "AUTHOR" 
.PP 
This manual page was written by Damyan Ivanov (dam@modsoftsys.com) for the 
\fBDebian\fP 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.   
.\" created by instant / docbook-to-man, Sat 25 Mar 2017, 15:14