Reference Manual
   CHAPTER 9. SQL Statements     

START DATABASE statement [ISQL]

Function 

To start a database on the specified database server

Syntax 

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

Permissions 

The required permissions are specified by the database server -gd command-line option. This option defaults to none on the personal database server, and dba on the network server.

Side effects 

None

See also 

STOP DATABASE statement

CONNECT statement

Description 

The START DATABASE statement starts a specified database on a specified database server. The database server must be running. The full path must be specified for the database-file, unless the file is located in the same directory.

The START DATABASE statement does not connect Interactive SQL to the specified database: a CONNECT statement needs to be issued in order 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:\asa6\asademo.db would be given the default name of asademo.

If engine-name is not specified, the default database 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.

Standards and compatibility 

• SQL/92     Vendor extension.

• Sybase     Not applicable.

Example 

• Start the database file c:\asa6\sample_2.db on the current server.

  START DATABASE 'c:\asa6\sample_2.db'

• Start the database file c:\asa6\sample_2.db as sam2 on the server named sample.

START DATABASE 'c:\asa6\sample_2.db'
AS sam2
ON sample ;