START DATABASE Statement [Interactive SQL]

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\16_0\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.

Note: Start only one database on a given SAP Sybase IQ database server.

Standards

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

Permissions

Requires the SERVER OPERATOR system privilege.