Go Up to Invoking isql
Only the initial characters in an option are required. You can also type any portion of the text enclosed in brackets, including the full option name. For example, specifying -n,
-no, or -noauto has the same effect.
isql Command-line Options
| Option
|
Description
|
|
-a
|
Extracts all DDL for the named database.
|
|
-c[ache]
|
Set number of cache buffers for this connection to the database; see Default Cache Size Per isql Connection.
|
|
-d[atabase] name
|
Used with -x; changes the CREATE DATABASE statement that is extracted to a file.
- Without
-d, CREATE DATABASE appears as a C-style comment and uses the database name specified on the isql command line.
- With
-d, isql extracts an uncommented CREATE DATABASE and substitutes <name> as its database argument.
|
|
-e[cho]
|
Displays (echoes) each statement before executing it.
|
|
-ex[tract]
|
Same as -x
|
|
-i[nput] file
|
Reads commands from an input file such as a SQL script file instead of from standard input.
- input files can contain
-input commands that call other files, enabling execution to branch and then return.
isql exits (with a commit) when it reaches the end of the first file.- In interactive sessions, use
-input to read commands from a file.
|
|
-m[erge_stderr]
|
- Merges stderr output with stdout.
- Useful for capturing output and errors to a single file when running
isql in a shell script or batch file.
|
|
-n[oauto]
|
Turns off automatic commitment of DDL statements; by default, DDL statements are committed automatically in a separate transaction.
|
|
-nowarnings
|
Displays warning messages if, and only if, an error occurs (be default, isql displays any message returned in a status vector, even if no error occurred).
|
|
-o[utput] file
|
Writes results to an output file instead of to standard output; in interactive sessions, use -output to write results to a file.
|
-pas[sword]
password
|
Used with -user
- Specifies a password when connecting to a remote server.
- For access, both <password> and <user> must represent a valid entry in the security database.
|
|
-page[length] n
|
Prints column headers every <n> lines instead of the default 20.
|
|
-q[uiet]
|
|
|
-r[ole] rolename
|
Grants privileges of role <rolename> to <user> on connection to the database.
|
|
-s[qldialect] n
|
Interprets subsequent commands as dialect <n> until end of session or until dialect is changed by a SET SQL DIALECT statement.
- For <n> = 1, commands are processed as in InterBase 5 or earlier.
- For <n> = 2, elements that have different interpretations in dialect 1 and 3 are all flagged with warnings or errors to assist in migrating databases to dialect 3.
- For <n> = 3, all statements are parsed as current InterBaseSQL semantics: double quotes are delimited identifiers,
DATE data type is SQL DATE, and exact numerics with precision greater than 9 are stored as INT64.
|
|
-t[erminator] x
|
Changes the end-of-statement symbol from the default semicolon (;) to <x>, where <x> is a single character or any sequence of characters; deprecated in InterBase 7.
|
|
-u[ser] user
|
Used with -password; specifies a user name when connecting to a remote server.
- For access, both <password> and <user> must represent a valid entry in the security database.
|
|
-x
|
Extracts DDL for the named database; displays DDL to the screen unless redirected to a file.
|
|
-z
|
Displays the software version of isql.
|