Interactive SQL is a utility that ships with SAP Sybase IQ that lets
you execute SQL statements, build scripts, and display database data.
To use Interactive SQL to run a sample query, the demo database must be up and running.
The connection parameters in this procedure use default login credentials and assume that
iqdemo is running locally. If you installed iqdemo
in another location or changed the default login, use those values instead.
- Open a console, and run dbisql from the
$IQDIR16/bin64 directory.
- On the Connect dialog, enter:
| Tab Name |
Field |
Value |
|---|
| Identification |
Authentication |
Database |
| User ID |
DBA or
dba
(case-insensitive) |
| Password |
sql
(case-sensitive) |
| Action |
Connect to a running database on this
computer |
| Server name |
<localhost>_iqdemo |
| Database name |
iqdemo |
| Network |
TCP/IP protocol
options |
Host |
<localhost> |
| Port |
2638 |
- In the SQL Statements window,
enter:
SELECT * FROM Employees
- Press F9 to run the query.
Note: Interactive SQL uses the
deprecated iAnywhere JDBC driver.