Connecting to the demo database from Sybase Central or Interactive SQL

Many examples and exercises throughout the documentation start by connecting to the demo database from Interactive SQL, also called dbisql.

StepsConnecting to the demo database (Sybase Central)

  1. Start Sybase Central as appropriate for your system.

    On UNIX, source the IQ-15_2.csh (or .sh) script before invoking utilities like Sybase Central or the IQ Agent.

    In a multiplex environment, if the IQ Agent is not started, type:

    %S99SybaseIQAgent15
    

    To start Sybase Central, type:

    % scjview
    

    NoteIf you have set environment variables as described in the Installation and Configuration Guide, you can issue the scjview command from any directory.

    On Windows, to start Sybase Central, choose Programs > Sybase > Sybase IQ 15.2 > Sybase Central.

  2. Choose Sybase IQ.

    This opens a panel on the right with multiple tabs.

  3. In the Utilities tab, double-click Open Interactive SQL.

  4. On the Identification tab, type DBA and sql for the User and Password.

  5. On the Database tab, choose Find.

  6. Select your iqdemo server from the Find Servers screen and click OK.

StepsConnecting to the demo database (Interactive SQL)

  1. Select Programs > Sybase > Sybase IQ 15.2 > Interactive SQL.

  2. Follow steps 4 – 6 in the previous procedure.

You can connect to any database server that is already running in the same manner. You can also specify a non-default character set and language.

For more information on using dbisql, see Chapter 2, “Using Interactive SQL (dbisql),”in the Utility Guide.