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. Use Interactive SQL to connect to the server and run a sample query.

  1. Select Start > Programs > Sybase > Sybase IQ 16.0 > Interactive SQL 16.0.
  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.
Note:

  • Interactive SQL does not support jConnect. Use the SQL Anywhere JDBC Driver instead. jConnect is provided with SAP Sybase IQ for customer application backward compatibility.

  • As a general rule, the jConnect driver cannot use ODBC data sources. You can, however, use the jConnect driver with Interactive SQL and specify an ODBC data source.

Parent topic: Testing Installed Products
Related concepts
Demo Database
Running SAP Sybase IQ Server
Starting and Stopping the Sybase Control Center Agent
Post-Installation Tasks