DatabaseSwitches connection parameter [DBS]

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 server is not already 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.

Note

The DatabaseName (DBN) connection parameter is recommended for naming databases, rather than using the -n option with the DatabaseSwitches (DBS) connection parameter.

See also
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.