START DATABASE Statement [Interactive SQL]

Quick Links:

Syntax

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

database-name – if 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.

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

AUTOSTOP – when set to YES (default), the database is unloaded when the last connection to it is dropped. When set to NO, the database is not unloaded.

KEY – to enter the KEY value (password) for strongly encrypted databases.

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

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
```

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.

Requires the SERVER OPERATOR system privilege.