Sybase Adaptive Server Anywhere - The Interactive SQL Utility

The Interactive SQL utility
106
The Interactive SQL utility
dbisql [ switches ] [ dbisql-command | command-file ]
Switch Description
–c "keyword=value; ..." Supply database connection parameters
–datasource dsn-name Specify an ODBC data source to connect to.
–host hostname Specify the hostname or IP address of the machine
running a database server.
-jConnect
Use jConnect to connect to the database.
–nogui
Run in command-prompt mode.
–ODBC
Use the JDBC/ODBC bridge to connect to the
database.
–port portnumber Look on the specified port number for the database
server.
–q
Quiet mode—no windows or messages
–x
Syntax check only—no commands executed
Interactive SQL provides the user with an interactive environment for
database browsing and for sending SQL statements to the database server.
Interactive SQL allows you to type SQL commands, or run command files. It
also provides feedback about the number of rows affected, the time required
for each command, the execution plan of queries, and any error messages.
If dbisql-command is specified, Interactive SQL executes the command. You
can also specify a command file name. If no dbisql-command is specified,
SQL enters interactive mode, where you can type a command into a
command window.
–c Specify connection parameters. See "Connection parameters" on
page 64 of the book ASA User’s Guide for a description of the connection
parameters. If Interactive SQL cannot connect, you are presented with a
dialog where you can enter the connection parameters.
–datasource Specify an ODBC data source to connect to. You do not
need to be using the JDBC/ODBC bridge 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 JDBC/ODBC bridge to connect. Adaptive Server Anywhere
data sources are configured to use TCP/IP by default.
Syntax
Description
Switches