DatabaseSwitches (DBS) connection parameter

{ DatabaseSwitches | DBS }=database-options

Connecting to a database server when the database is not started. This connection parameter starts a database server automatically with the specified database and options if a database server is not running.

database-options This string specifies options that apply to the database file. See Database options (dbeng12/dbsrv12).
Database server options must be supplied using the StartLine connection parameter. See StartLine (START) connection parameter.

No options.

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.

Note

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

The following command, 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=%SQLANYSAMP12%\demo.db;DBN=my-db;DBS=-r"

DatabaseSwitches (DBS) connection parameter

Syntax

Usage

Allowed values

Default

Remarks

Note

See also

Example