Running a Sample Query

Interactive SQL is a utility that ships with Sybase IQ. Use Interactive SQL to connect to the server and run a sample query.

1. Click Start > Programs > Sybase > Sybase IQ 15.4 > Interactive SQL.
   Interactive SQL starts and opens a connection dialog.
2. Use these connection parameters:

   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
   SalesOrders.ID,
   SalesOrders.OrderDate,
   Customers.CompanyName
   
   FROM SalesOrders 
   KEY JOIN Customers
   WHERE OrderDate > '1994/01/01'
   ORDER BY OrderDate

   Other query options are available. See Installation and Configuration > Testing Installed Products > Demo Database > Table Names for a list of tables and owners.
4. Press F9 to run the query.
5. Click File > Exit to exit Interactive SQL.