ASA Database Administration Guide
  Connection and Communication Parameters
    Connection parameters

DatabaseSwitches connection parameter [DBS]

Function 

To provide database-specific options (switches) when starting a database.

Usage 

Connecting to a server when the database is not loaded. This connection parameter autostarts an engine with the specified database and options if a server is not already running.

Values 

String

Default 

No options

Description 

You should supply DatabaseSwitches only if you are connecting to a database that is not currently running. When the server starts the database specified by DatabaseFile, the server uses the supplied DatabaseSwitches to determine startup options for the database.

Only database options (switches)

can be supplied using this parameter. Server switches must be supplied using the StartLine connection parameter.

For information about database options, see Database options.

Example 

• The following command, entered all on one line at a command prompt, connects to the default database server, loads the database file asademo.db (DatabaseFile (DBF) connection parameter), names it as my_db (DBS parameter) and connects to the database of that name (DatabaseName (DBN) connection parameter).

  dbisql -c "uid=DBA;pwd=SQL;dbf=c:\Program Files\Sybase\SQL Anywhere 9\asademo.db;dbn=my_db;dbs=-n my_db"

See also 

The database server

StartLine connection parameter [START]