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
|