Starting dbisql

In this section, you can practice starting IQ and dbisql.

You can start Interactive SQL in two ways: from Sybase Central or on its own. 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 the Introduction to Sybase IQ.

To open Interactive SQL from Sybase Central

In the left pane, select the Sybase IQ plug-in.

In the right pane, click the Utilities tab.

Double-click Open Interactive SQL in the right pane.

The Interactive SQL window appears.

Supply parameters following the steps in “Supplying connection parameters”.

Tip You can also access Interactive SQL by choosing Start → Programs → Sybase → Adaptive Server IQ 12.6 → Interactive SQL Java, or from within Sybase Central by choosing any of the following options:

Choosing Tools → Sybase IQ → Open Interactive SQL.
Selecting a database in the left pane, and choosing Open Interactive SQL from the File menu.
Right-clicking a database, and choosing Open Interactive SQL from the pop-up menu.
Right-clicking a stored procedure, and choosing Execute from Interactive SQL from the pop-up menu. Interactive SQL opens with a CALL to the procedure in the SQL Statements pane and executes the stored procedure.

To start Interactive SQL from Sybase Central:

To start Interactive SQL, right-click the server and choose Interactive SQL from the pop-up menu. In this case, Interactive SQL automatically connects to the database.

To start Interactive SQL without a connection to a database, choose Sybase IQ 12 → Utilities → Open Interactive SQL. The Connect dialog automatically appears.

To start dbisql on UNIX:

Start the sample database server, if it isn't already running. To do this, change to the demo directory and use the following command format:
```
% start_asiq -n servername asiqdemo.db  
```
For servername, substitute a unique server name, for example, your system name, database name, and port number, separated by an underscore.

If you specify -n servername without a dbname, it connects to the default database on the current server. If you specify -n dbname without a servername, it connects to that database on the current server.

For example, enter the following commands at system prompts:
```
cd $SYBASE/ASIQ-12_6/demo
start_asiq -n fiona_asiqdemo_1870 asiqdemo.db
```
To start dbisql, type the following command at a system prompt: dbisql

To start dbisql on Windows:

From the Start menu, choose Programs → Sybase → Adaptive Server IQ 12.6 → Interactive SQL Java.

The Connect dialog appears.

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.