On UNIX-like operating systems, ODBC data sources are stored in a system information file. Although this file is named .odbc.ini by default, it can have any name.
[My Data Source] Userid=DBA Password=sql EngineName=test_server CommLinks=tcpip(port=1870) AutoStop=no DatabaseName=iqdemo DatabaseFile=iqdemo.db
You can create and manage ODBC data sources with the iqdsn utility. See "Data Source Utility (iqdsn) in the Utility Guide.
The $ODBCINI environment variable
The $HOME environment variable
$ODBC_HOME
$ODBC_INI
% dbisql –c "dsn=sample_dsn"
Any database started from a connection string is, by default, stopped when there are no more connections to it, and any database that is loaded from a connection string is unloaded as soon as there are no more connections to it when the Autostop connection parameter is set to yes. This does not apply to multiplex IQ databases started with Sybase Central.
% dbisql –c "UID=DBA;PWD=sql;AutoStop=no; ENG=<engine name>;DBF=$IQDIR15/demo/iqdemo.db"This example is shown on multiple lines, however, you must enter the entire command at the command prompt on one line.