Sybase Adaptive Server Anywhere - STOP ENGINE Statement

STOP ENGINE statement
626
STOP ENGINE statement
Use this statement to stop a database server.
STOP ENGINE [ engine-name ]
… [ UNCONDITIONALLY ]
The permissions to shut down a server depend on the -gd command-line
setting on the database server command line. The default setting is all for the
personal server, and dba for the network server.
None
"START ENGINE statement" on page 622
"–gd command-line option" on page 26
The STOP ENGINE statement stops the specified database server. If the
UNCONDITIONALLY keyword is supplied, the database server is stopped
even if there are connections to the server. By default, the database server
will not be stopped if there are connections to it.
STOP ENGINE clause The engine-name can be used in Interactive SQL
only. If you are not running this statement in Interactive SQL, the current
database is stopped.
UNCONDITIONALLY keyword If you are the only connection to the
database server, you do not need to use UNCONDITIONALLY. If there are
other connections, the database server stops only if you use the
UNCONDITIONALLY keyword.
♦
SQL/92 Vendor extension.
♦
Sybase Not applicable.
♦ Stop the current database server, as long as there are no other
connections.
STOP ENGINE
Function
Syntax
Permissions
Side effects
See also
Description
Parameters
Standards and
compatibility
Example