An embedded database, designed for use by a single application, runs on the same machine as the application and is largely hidden from the application user.
When an application uses an embedded database, the database is generally not running when the application connects. You can start the database using the connection string, and by specifying the database file in the DatabaseFile (DBF) parameter of the connection string.
The DBF parameter specifies which database file to use. The database file automatically loads onto the default server, or starts a server if none is running.
The database unloads when there are no more connections to the database (generally when the application that started the connection disconnects). If the connection started the server, it stops once the database unloads.
Use these connection parameters to load the demo database as an embedded database:
dbf=path\iqdemo.db uid=DBA pwd=sql
where path is the name of your SAP Sybase IQ installation directory.
The following connection parameters show how to customize the startup of the demo database as an embedded database. You may find this useful if you use command-line options, such as the cache size:
Start=start_iq -gd all -gl all -gm 10 -gn 25 -gp 4096 -c 32M -ti 4400 -tl 300 dbf=path\iqdemo.db uid=DBA pwd=sql