ASA SQL Reference
  SQL Statements

START DATABASE statement

Description 

Use this statement to start a database on the current database server.

Syntax 

START DATABASE database-file
[ AS database-name ]
[ ON engine-name ]
[ WITH TRUNCATE AT CHECKPOINT ]
[ FOR READ ONLY ]
[ AUTOSTOP { ON | OFF } ]
[ KEY key ]

Parameters 

START DATABASE clause    The database-file parameter is a string. If a relative path is supplied in database-file, it is relative to the database server starting directory.

AS clause    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:\Database Files\asademo.db would be given the default name of asademo.

ON clause    This clause is supported from Interactive SQL only. In Interactive SQL, if engine-name is not specified, the default database is the first started server among those currently running.

WITH TRUNCATE AT CHECKPOINT clause    Starts a database with log truncation on checkpoint enabled.

FOR READ ONLY    Starts a database in read-only mode.

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

In Interactive SQL, you can use YES or NO as alternatives to ON and OFF.

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

Usage 

Starts a specified database on the current database server.

The START DATABASE statement does not connect the current application to the specified database: an explicit connection is still needed.

Interactive SQL supports the ON clause, which allows the database to be started on a database server other than the current.

Permissions 

The required permissions are specified by the database server -gd option. This option defaults to all on the personal database server, and DBA on the network server.

Side effects 

None

See also 

STOP DATABASE statement

CONNECT statement [ESQL] [Interactive SQL]

-gd server option

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not applicable.

Example 

Start the database file C:\Database Files\sample_2.db on the current server.

START DATABASE 'c:\database files\sample_2.db'

From Interactive SQL, start the database file c:\Database Files\sample_2.db as sam2 on the server named sample.

START DATABASE 'c:\database files\sample_2.db'
AS sam2
ON sample