Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 74 / 536

Simple connection examples
54
For steps in connecting to a database using Sybase Central, see the Introduction
to Adaptive Server IQ. For more detailed information on available connection
parameters and their use, see “Connection parameters” on page 73.
Connecting to a database from DBISQL
Many examples and exercises throughout the documentation start by
connecting to the sample database from Interactive SQL, also called DBISQL.
Here is how to carry out this step.
Note
To avoid ambiguity, specify connection parameters for DBISQL instead
of relying on defaults. You can specify connection parameters in a command
line or an initialization file such as .odbc.ini or odbc.ini. For a complete list, see
Chapter 3, “Connection and Communication Parameters” in Adaptive Server
IQ Reference Manual.
If more than one database is started on a server, for example, you should
specify the database name. In a network with subnets, specify the
CommLinks
parameter with protocol options including the host number.
In the .odbc.ini file, you must use the long form of each parameter. For
example, use DatabaseFile instead of DBF.
If your parameters are incomplete or incorrect, you may see an error such as
Database name required to start engine
❖
To connect from a UNIX system:
1 Make sure that your PATH and other environment variables are correctly
set, as described in Chapter 1, “File Locations and Installation Settings” in
the Adaptive Server IQ Reference Manual.
2 To ensure that the sample database is loaded on a running server, at the
UNIX prompt enter:
ps -eaf | grep asiqdemo
If you need to start the sample database, enter:
cd $ASDIR/demo
start_asiq @asiqdemo.cfg asiqdemo
3 If you have not already done so, change to your home directory ($HOME)
and issue the following command to copy the terminfo extension file
default.tix into it: