Step 3: Start Interactive SQL

In this section you start the Interactive SQL utility, connect to the sample database, and enter a command.

To start Interactive SQL and connect to the sample database (Windows)

Start Interactive SQL:
- Choose Start > Programs > SQL Anywhere 9 > Adaptive Server Anywhere > Interactive SQL.
  
  The Connect dialog appears.
Connect to the sample database.
- On the Database tab, enter the Server name asademo9.
- On the Identification tab, enter the user ID DBA and the password SQL.
- Click OK to connect.
The Interactive SQL window appears.
Enter a command.

In the SQL Statements pane, enter a SQL statement such as the following and press F5 to execute the query:
```
SELECT * FROM CUSTOMER
```
The result set for the query appears in the Results pane.

To start Interactive SQL and connect to the sample database (Command line)

From a command prompt, enter the following command:
```
dbisql
```
The Connect dialog appears.
Connect to the sample database.
- On the Database tab, enter the Server name asademo9.
- On the Identification tab, enter the user ID DBA and the password SQL.
- Click OK to connect.
Enter a command in the Interactive SQL window.

In the SQL Statements pane, enter a SQL statement such as the following and press F5 to execute the query:
```
SELECT * FROM CUSTOMER
```
The result set for the query appears in the Results pane.

You can enter any SQL statement against the database from within Interactive SQL. For a complete list of SQL statements, see SQL Statements.

For more information about Interactive SQL, see Using Interactive SQL.