Some users may prefer to use the older Interactive SQL utility, now called Interactive SQL Classic, that shipped with versions of IQ prior to 12.7. Note that although dbisqlc is supported, dbisqlc does not contain all the features of the Java version dbisql. Once a database server is running, you can connect to the server from dbisqlc. This example describes connecting to the sample database asiqdemo.
To start dbisqlc and connect
to a database from the command prompt:
Ensure that the sample database is loaded on a running server, as described in “Starting the database server” in Chapter 3, “Running and Connecting to Servers” of the Introduction to Sybase IQ.
Start dbisqlc by entering:
dbisqlc -c "uid=DBA;pwd=SQL"
at the command prompt on your UNIX or Windows system.
The –c parameter specifies connection parameters. For a complete list of connection parameters, see Chapter 4, “Connection and Communication Parameters” in the Sybase IQ System Administration Guide.
The default user ID and password for the asiqdemo database
and other IQ databases are “DBA” and “SQL.” You
must always type the password in uppercase, because the default
setting is CASE RESPECT. (User IDs are never
case sensitive.) However, if you connect to a database created with
Adaptive Server Anywhere, the default may be lowercase. If you have
trouble connecting to a database, try changing the case of the user
ID and password that you supply.
To start dbisqlc and connect to a database on
Windows
Start the server, as described in “Starting the database server” in Chapter 3, “Running and Connecting to Servers” of the Introduction to Sybase IQ.
Select Start > Programs > Sybase > Adaptive Server IQ 12.7 > Interactive SQL Classic
The dbisqlc Connect window appears.
On the Login tab, enter the user ID
DBA
and the password
SQL
This is the default user ID and password for Sybase IQ databases when they are created. (The password does not appear when you type it. This prevents someone else from seeing your password.) By default, the password is case sensitive for a case sensitive database; the user ID is not.
Click the Database tab and type the server name (for example, “hostname_asiqdemo” for the demo database). If your server is on a remote machine, make sure that you select the checkbox “Search network for database servers,” which is unchecked by default.
On the Network tab, select TCPIP.
If your database is on a remote machine, you must add host information in the space beside TCPIP by typing “host=servername:nnnn” where servername is the name of your system and nnnn is your port number. (The default port number is 2638, but if the host was started with a different number, use that instead.)
Click OK to connect to the database.
