Running Interactive SQL

Interactive SQL is a utility that ships with 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. From the Sybase Program Group, select Sybase IQ 15.4Interactive SQL 15.4.
  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
  3. In the SQL Statements window, enter:
    SELECT * FROM Employees
  4. Press F9 to run the query.
Note:

  • Sybase Central and Interactive SQL do not support jConnect. Use the SQL Anywhere JDBC Driver instead. jConnect is provided with Sybase IQ 15 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.

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