Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Interactive SQL Online Help Interactive SQL Version 16.0 » Interactive SQL Help » Starting Interactive SQL

Opening Interactive SQL using the dbisql command-line utility

Interactive SQL allows you to type SQL commands or run command files using the dbisql utility. dbisql also provides feedback about the number of rows affected, the time required for each command, the execution plan of queries, and any error messages.

The syntax for dbisql is:

dbisql [ option] [ dbisql_command | command_file ]

If you include dbisql_command, Interactive SQL executes the command. You can also specify a command file name. If you do not specify dbisql_command or command_file, Interactive SQL enters interactive mode, where you can type a command into a command window.

Exit codes are 0 (success) or non-zero (failure).

Table 1-1 describes the command-line options available for dbisql.

Table 1-1: dbisql command-line options




Supply database connection parameters

-d delimiter

Use the given string as the command delimiter.


Print statements as they are executed (command-prompt mode only).

-datasource dsn_name

Specify an ODBC data source to connect to.

-f file_name

Open (without running) the file called file_name.

-host host_name

Specify the host_name or IP address of the machine running a database server.


Run in command-prompt mode.

-onerror {continue | exit}

Override the ON_ERROR option for all users.

-port port_number

Look on the specified port number for the database server.


Quiet Mode – do not display messages or windows (Note that this does not suppress error messages).


Syntax check only; no commands executed.

Usage information