START DATABASE Statement [Interactive SQL]

Starts a database on the specified database server.

Syntax

START DATABASE database-file
… [ AS database-name ]
… [ ON engine-name ]
… [ AUTOSTOP { YES | NO } ]
… [ KEY key ]

Examples

Example 1 – On a UNIX system, start the database file /s1/sybase/sample_2.db on the current server:
```
START DATABASE '/s1/sybase/sample_2.db'
```
Example 2 – On a Windows system, start the database file c:\sybase\sample_2.db as sam2 on the server eng1:
```
START DATABASE 'c:\sybase\sample_2.db'
AS sam2
ON eng1
```

Usage

The database server must be running. The full path must be specified for the database file unless the file is located in the current directory.

The START DATABASE statement does not connect dbisql to the specified database: a CONNECT statement must be issued to make a connection.

If database-name is not specified, a default name is assigned to the database. This default name is the root of the database file. For example, a database in file c:\sybase\IQ_15\demo\iqdemo.db is given the default name iqdemo.

If engine-name is not specified, the default database server is assumed. The default database server is the first started server among those currently running.

The default setting for the AUTOSTOP clause is YES. With AUTOSTOP set to YES, the database is unloaded when the last connection to it is dropped. If AUTOSTOP is set to NO, the database is not unloaded.

If the database is strongly encrypted, enter the KEY value (password) using the KEY clause.

Sybase recommends that you start only one database on a given Sybase IQ database server.

Standards

SQL—Vendor extension to ISO/ANSI SQL grammar.
Sybase—Not applicable.

Permissions

Must have DBA authority.