Connecting to the Demo Database from Sybase Central

Many examples and exercises throughout the documentation start by connecting to the demo database.

  1. Start Sybase Central as appropriate for your system.

    On UNIX, source the IQ-15_4.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
    Note: If 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.4 > 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.

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.

Related concepts
Additional Dbspaces
Creating Primary Keys