Collection Contents Index SIGNAL statement START ENGINE statement [ISQL] pdf/chap9.pdf

Reference Manual
   CHAPTER 9. SQL Statements     



To start a database on the specified database server


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


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 


See also 


CONNECT statement


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 


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

Collection Contents Index SIGNAL statement START ENGINE statement [ISQL] pdf/chap9.pdf