Many examples and exercises throughout the documentation start by connecting to the sample database from Interactive SQL, also called DBISQL.
Connecting to the sample database (Sybase Central)
Start Sybase Central as appropriate for your system.
On UNIX, you must source the ASIQ-12_7.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:
% $ASDIR/bin/S99SybaseIQAgent12
To start Sybase Central, type:
% cd $SYBASE/sybcentral
% scjview
If you have set environment variables as described in
the Sybase IQ Installation and Configuration Guide, you can issue the scjview command
from any directory.
On Windows, to start Sybase Central, choose Programs > Sybase > Adaptive Server IQ 12 > Sybase Central Java Edition.
Choose Sybase IQ.
This opens a panel on the right with multiple tabs.
In the Utilities tab, double-click Open Interactive SQL.
On the Identification tab, type DBA and SQL for the User and Password.
On the Database tab, choose Find.
Select your asiqdemo server from the Find Server screen and click OK.
Connecting to the sample database (Interactive
SQL)
To start Interactive SQL from the Start menu, choose Programs > Sybase > Adaptive Server IQ 12 > Interactive SQL Java.
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 Sybase IQ Utility Guide.
