IBPhoenix Development

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
     
This Site Uses:

A Quick Guide to ISQLs Switches and Commands for Firebird/InterBase

By Claudio Valderrama C.

isql -optionA -optionB -optionC...

Options Are:

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

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 as 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
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 automatically
autofetch=> currently useless. It should be protected by #ifdef SCROLLABLE_CURSORS in the source code
width <colname> <size>=> sets size for display purposes
transaction=> starts a transaction with the required isolation level, wait mode and protection mode
term <t>=> the infamous terminator
names <cs>=> has an effect only before CONNECT; changes session character set
time=> time portion shown for dialect 1 timestamp fields?
sql dialect <n>=> set SQL dialect