You can start Interactive SQL (dbisql) in two ways: from Sybase Central or in standalone mode.
For detailed information on connecting to databases, see Chapter 3, “Running and Connecting to Servers” in Introduction to Sybase IQ.
Starting Interactive SQL from Sybase Central
In the left pane, select the Sybase IQ plug-in.
Choose Tools | Sybase IQ 15 | Open Interactive SQL.
In the Connect window, supply parameters as described in “Interactive SQL connection parameters”.
Tip
You can also access Interactive SQL from within Sybase Central
by :
Selecting a database in the left pane, and choosing File | Open Interactive SQL.
Right-clicking a database, and choosing Open Interactive SQL.
Right-clicking a stored procedure, and choosing Execute from Interactive SQL. Interactive SQL opens with a CALL to the procedure in the SQL Statements pane and executes the stored procedure.
Starting Interactive SQL from
the Windows Start menu
Select Start | Programs | Sybase | Sybase IQ 15.2 | Interactive SQL.
In the Connect window, supply parameters as described in “Interactive SQL connection parameters”.
Starting Interactive SQL from a command prompt
(Windows)
Start the IQ server. Change to a directory where the configuration and database files reside and issue a command in this format:
start_iq @configuration_file.cfg dbname.db
For example, to start the demo database, enter:
start_iq @iqdemo.cfg iqdemo.db
See the following for detailed information on starting the database server:
“Starting servers with the startup utility”in the System Administration Guide: Volume 1
Quick Start
Do one of the following:
In a command
shell, enter dbisql
Select Start | Run and enter dbisql
Starting Interactive SQL from a command prompt
(UNIX)
Start the IQ server. Change to a directory where the configuration and database files reside and issue a command in this format:
start_iq @configuration_file.cfg dbname.db
For example, to start the demo database, enter:
start_iq @iqdemo.cfg iqdemo.db
See the following for detailed information on starting the database server:
“Starting servers with the startup utility”in the System Administration Guide: Volume 1
Quick Start
Type the following command at a system prompt:
dbisql
