dbisql utility options

-c "keyword=value; ..."

Specifies connection parameters. See Chapter 4, “Connection and Communication Parameters” in the System Administration Guide: Volume 1 for a description of the connection parameters. If you do not specify this option, the environment variable SQLCONNECT is used. If Interactive SQL cannot connect, you see a dialog box where you can enter the connection parameters.

-d delimiter

Specifies a command delimiter. Quotation marks around the delimiter are optional, except when the command shell itself interprets the delimiter in some special way.

Command delimiters are used for all connections in that Interactive SQL session, regardless of the setting stored in the database (for the user, or the PUBLIC setting).

-d1

(The final character is the number 1, not a lower case L.) Echoes all statements that Interactive SQL executes to the Command window (STDOUT). This feedback is useful when debugging SQL scripts, or when Interactive SQL is processing a long SQL script

-datasource dsn-name

Specifies an ODBC data source to connect to. You do not need to be using the iAnywhere JDBC driver to use this option. However, if the data source to which you are connecting is not configured to use TCP/IP, you must use the iAnywhere JDBC driver to connect. By default, Sybase IQ data sources are configured to use TCP/IP.

-f file name

Opens (but does not run) the file called file name. You must enclose the file name in quotes if the file name contains a blank; otherwise, quotes are optional. If the file does not exist, or if it is a directory instead of a file, Interactive SQL prints an error message to the console and quits. If the file name does not include a full drive and path specification, the file is assumed to be relative to the current directory.

-host host name

Specifies the host name or IP address of the computer on which the database server is running. You can use the name localhost to represent the current machine.

-nogui

Runs Interactive SQL in a command-prompt mode, with no windowed user interface. This is useful for batch operations. If you specify either dbisql-command or command-file, then -nogui is assumed.

In -nogui mode, Interactive SQL sets the program exit code to indicate success or failure. On Windows operating systems, the environment variable ERRORLEVEL is set to the program exit code. Exit codes are:

• 0 — Success.

• 1 — General failure. At some point, a SQL or Interactive SQL statement did not execute successfully and the you chose to stop executing SQL statements. Alternatively, Interactive SQL noted an internal error.

• 5 — User terminated Interactive SQL. When an error occurs during execution, you are prompted to ignore the error, stop, or exit Interactive SQL. If you opt to exit, the program returns code 5.

• 9 — Unable to connect.

• 255 — Bad command. The command line contained incomplete or invalid switches.

-onerror (continue | exit)

Controls what happens if an error is encountered while reading statements from a command file. This option overrides the on_error setting. This option is useful when using Interactive SQL in batch operations.

-port portnumber

Specifies the port number on which the database server is running. The default port number for Sybase IQ is 2638.

-q

Runs in quiet mode—does not display output messages. This option is useful only if you start Interactive SQL with a command or command file. Specifying this option does not suppress error messages.

See “Setting quiet mode prerequisites”.

-version

Displays the version number of Interactive SQL.

-x

Scans commands but does not execute them. You may find this option useful for checking long command files for syntax errors.