ASA SQL Reference
  SQL Statements

STOP ENGINE statement

Description 

Use this statement to stop a database server.

Syntax 

STOP ENGINE [ engine-name ] [ UNCONDITIONALLY ]

Parameters 

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 server 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.

Usage 

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.

Permissions 

The permissions to shut down a server depend on the -gk setting on the database server command line. The default setting is all for the personal server, and DBA for the network server.

Side effects 

None

See also 

START ENGINE statement [Interactive SQL]

-gk server option

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not applicable.

Example 

Stop the current database server, as long as there are no other connections.

STOP ENGINE