Interactive SQL is a utility that ships with Sybase IQ that lets you execute SQL statements, build scripts, and display database data.
Starting Interactive SQL opens a dialog that lets you define the connection parameters to your server or database. If you need connection help, click the arrow in the top-right corner to display a Connect Assistant.
Starting Interactive SQL and running queries
Assume that iqdemo is running on a local host named localhost-xp.
Run dbisql from the $IQDIR15/bin <64> or $IQDIR15/bin<32> directory. Interactive SQL starts and displays a connection dialog.
On the Identification tab, type DBA in the User box, and sql in the Password box. DBA is not case-sensitive; sql is case-sensitive, and must appear in all lowercase letters.
On the Database tab, choose a server from the Server name box. If there are no servers listed, click Find to search for running servers.
Server names appear in this format <hostname>_dbname. If the host name is localhost-xp and you are running the demo iqdemo database, the server name is localhost-xp_iqdemo.
Choose iqdemo as the database. If there is only one database running, you can leave this field blank.
What you do next depends on the server location:
If you are running Interactive SQL against a server installed on the same machine, you must also choose an appropriate database file.
If you are running Interactive SQL against a networked server, click the Network tab, click the TCP/IP box, then specify the Host name and Port number.
Click OK to open Interactive SQL.
In the SQL Statements window, type:
SELECT * FROM employees
To execute the query, click the right-facing triangle on the toolbar.
Sybase Central and Interactive SQL no longer support jConnect. Sybase Central and Interactive SQL use the SQL Anywhere JDBC Driver. jConnect is provided with Sybase IQ 15.2 for customer application backward compatibility purposes.
As a general rule, the jConnect driver cannot use ODBC data sources. However, Sybase Central and Interactive SQL are special cases. When you use the jConnect driver in either of them, you can specify an ODBC data source to establish a connection.