""Rado Benc"" <bego@...> wrote in message
news:JCEKKCPJEELBFPAHKFCAKELLCDAA.r.benc@......

> Dear all,
>
> Where can I get relevant information about isql command
> line switches (preferably for Firebird).

Reading the source code. :-)

> I noticed that
> there were some changes / additions. I found my documentation
> a bit outdated (downloaded yesterday from Borland site, the one
> linked from ibphoenix does not seem to be accurate anyway).

isql -optionA -optionB -optionC...
Options:
X or EX = extract metadata
A = extract all metadata
E = echo
M = merge stderr with stdout
NOW = don't display warnings (from the engine)
NOA = no autocommit
O <ofile> = output file
I <ifile> = input file
T <term> = set terminator
D <db> = database name
PAG <len> = set page length
P <pw> = password
U <usr> = user
R <role> = role => I found a bug here, the role is always uppercased
C <cache> = cache buffers
Q = quiet operations
Z = display version
S <dialect> = set SQL dialect

I think they are all documented in the Operations Guide.

Interactive commands or commands that can be included in a script:
Show <object [name]>
Add => add a row to a table
Copy => creates one table with the same structure than the original
blobView => calls an editor with the blob contents
blobDump => writes a file with the blob contents
output => redirects output to a file
shell => invokes the operating system shell
create database <options>
drop database
connect <options>
edit => loads a blob from a temporary file after an editor is called to open
it (no guarantee that it may be working today)
input => takes input from a file and executes it immediately
quit => finish, rollback
exit => finish, commit
help

The following are SET commands:
stats => statistics on performance: read, writes, etc.
count => number of rows affected as returned by the API
list => show fields in vertical way
plan => activate plan information
planonly => do not execute statements; only show the plan that would be used
blob OFF|<n>|ALL => shows blob contents of no blob type, type N or all types
echo => reflects input
autoddl => DLL (metadata commands) are committed automagically
autofetch => currently useless. It should be protected by
#ifdef SCROLLABLE_CURSORS in the source code... I'm doing this now.
width <colname> <size> => sets size for displaying purposes
transaction => starts a transaction with the needed isolation level, wait
mode and protection mode.
term <t> => the infamous terminator
names <cs> => has effect only before CONNECT; changes session charset
time => is time portion shown for dialect 1 databases in timestamp fields?
sql dialect <n> => you guess

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing