Provides database-specific options when starting a database.

Usage

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

Values

String

Default

No options.

Remarks

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 can be supplied using this parameter. Server options must be supplied using the StartLine connection parameter.

See Database options.

See also

• The SQL Anywhere database server
• StartLine connection parameter [START]
• Connection parameters
• Resolving connection parameter conflicts
• DatabaseName connection parameter [DBN]

Example

The following command, entered on one line at a command prompt, connects to the default database server, loads the database file demo.db (DatabaseFile (DBF) connection parameter), names it my-db (DatabaseName (DBN) connection parameter) and starts it in read-only mode (-r option).

dbisql -c "UID=DBA;PWD=sql;DBF=samples-dir\demo.db;DBN=my-db;DBS=-r"

For information about samples-dir, see Samples directory.