You can start Interactive SQL in two ways: from Sybase Central or in standalone mode. The way that you start Interactive SQL on its own depends on your operating system.
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 “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 in
standalone mode on Windows
Select Start > Programs > Sybase > Sybase IQ 15.1 > Interactive SQL Java.
In the Connect window, supply parameters as described in “Connection parameters”.
Starting Interactive SQL in standalone mode on UNIX
If the sample database server is not already running, change to the demo directory and execute the following command:
% start_iq -n servername iqdemo.db
For servername, substitute a unique server name, for example, your system name, database name, and port number, separated by an underscore.
For example:
cd $SYBASE/IQ-15_1/demo start_iq -n fiona_iqdemo_1870 iqdemo.db
If you specify -n servername without
a dbname, the server connects to the default
database on the current server. If you specify -n dbname without
a servername, Sybase IQ connects to that database
on the current server.
To start dbisql, type the following command at a system prompt: dbisql
Once the database server is running, you can also start dbisql by
typing dbisql at the Command
Prompt or by right-clicking the server name in Sybase Central and
choosing Interactive SQL from the pop-up menu
