User's Guide Part VI. SQL Anywhere Reference Chapter 39. SQL Anywhere Componentsisql [switches] [isql-command]
rtsql [switches] [isql-command]
isqlw [switches] [isql-command]
rtsqlw [switches] [isql-command]
| Switch | Description |
|---|---|
| -b | Do not print banner |
| -c"keyword=value; ..." | Supply database connection parameters |
| -k | Close window when finished (RTSQL only) |
| -q | Quiet mode---no windows or messages |
| -v | Verbose---output information on commands |
| -x | Syntax check only---no commands executed |
ISQL provides the user with an interactive environment for database browsing and for sending SQL statements to SQL Anywhere.
ISQL allows you to type SQL commands, or run ISQL 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 isql-command is specified, then ISQL executes the command. The most common form uses the READ statement to execute an ISQL command file in batch mode. If no isql-command is specified, then ISQL enters the interactive mode where you can type a command into a command window.
The Windows 3.x executable name is ISQLW. You can set up Program Manager icons to start ISQLW with the same command line syntax as specified above.
RTSQL and RTSQLW are runtime SQL command processors. These programs are included in the SQL Anywhere Runtime System for Windows 3.x, 95, or NT, OS/2, or DOS. They are like ISQL except there is no interactive part; they can only run command files. By including RTSQL commands, SQL command files can be run from operating system batch or command files. RTSQL automatically loads the database engine if it is not already loaded. It unloads the database engine on exit. The command line switches are the same as those of ISQL.
-b Do not print the identification banner when ISQL starts up.
-c "keyword=value; ..." Specify connection parameters. See "Database connection parameters" for a description of the connection parameters. If this option is not specified, the environment variable SQLCONNECT is used. If required connection parameters are not specified, then you are presented with a dialog to enter the connection parameters.
-k Close the window when RTSQL is finished. This switch applies only to RTSQL in Windows 3.x, Windows 95, and Windows NT.
-q Operate quietly. ISQL does not display any information on the screen. This is only useful if a command or command file is executed when starting ISQL.
-v Verbose output. Information about each command is displayed as it is executed (RTSQL only).
-x Scan commands but do not execute them. This is useful for checking long command files for syntax errors.
ISQL commands are broken into the following groups:
CONFIGURE Statement Activate the ISQL configuration window for displaying and changing ISQL options
CONNECT Statement Reconnect to the database engine with a different user ID and password
DBTOOL Statement Invoke one of the database tools
DISCONNECT Statement Disconnect from the database engine
EXIT Statement Leave ISQL
HELP Statement Enter the online Help facility
INPUT Statement Do mass input into database tables
OUTPUT Statement Output the current query results to a file
PARAMETERS Statement Specify the parameters to a command file
QUIT Statement Leave ISQL
READ Statement Execute ISQL command files
SET CONNECTION Statement Change the active database connection
SET OPTION Statement Set options that control the ISQL environment
SYSTEM Statement Executes an operating system command (not available in Windows 3.x).
The data window manipulation commands are as follows (these commands are not described in the command summary section):
CLEAR Statement Clear the data window
DOWN [n] Move the current query results down n lines. The default is one line.
UP [n] Move the current query results up n lines. The default is one line.
For detailed descriptions of SQL statements and ISQL commands, see the chapter "Watcom-SQL Language Reference".
You can start ISQL from Sybase Central in the following ways: