START DATABASE statement
620
START DATABASE statement
Use this statement to start a database on the current database server.
START DATABASE
database-file
… [ AS
database-name
]
… [ ON
engine-name
]
… [ AUTOSTOP { ON | OFF } ]
The required permissions are specified by the database server -gd command-
line option. This option defaults to all on the personal database server, and
dba on the network server.
None
"STOP DATABASE statement" on page 625
"CONNECT statement" on page 423
"–gd command-line option" on page 26
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.
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.
If you use this statement in Interactive SQL, database-file is interpreted
relative to the Interactive SQL current 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:\asa6\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.
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.
Function
Syntax
Permissions
Side effects
See also
Description
Parameters
To Next Page
Loading...