Show TOC

Running Interactive SQLLocate this document in the navigation structure

Interactive SQL is a utility that ships with SAP IQ that lets you execute SQL statements, build scripts, and display database data.

Context

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.

Procedure

  1. Open a console, and run dbisql from the $IQDIR16/bin64 directory.
  2. 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
  3. In the SQL Statements window, enter: SELECT * FROM Employees
  4. Press F9 to run the query.

Results

Note

Interactive SQL uses the deprecated iAnywhere JDBC driver.

Related Information