START DATABASE Statement [Interactive SQL]

Quick Links:

Syntax

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

Parameters

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:\SAP\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 that are 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 IQ database server.

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 you must also issue a CONNECT statement to make a connection.

Standards

Permissions

Requires the SERVER OPERATOR system privilege.