User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To start a database on the specified database engine

Syntax

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

Usage

ISQL

Permissions

None

Side effects

None

See also

• STOP DATABASE statement
• CONNECT statement

Description

The START DATABASE statement starts a specified database on a specified database engine. The database engine 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 ISQL 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:\SQLANY50\SADEMO.DBwould be given the default name of sademo.

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

Example

Start the database file C:\SQLANY50\SAMPLE_2.DB on the current engine.

     start database 'c:\sqlany50\sample_2.db'

Start the database file C:\SQLANY50\SAMPLE_2.DB as sam2 on the engine named sample.

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