Running Interactive SQL

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>`
Network	TCP/IP protocol options	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.