ASA SQL Reference
  SQL Statements

START ENGINE statement [Interactive SQL]

Description 

Use this statement to start a database server.

Syntax 

START ENGINE AS engine-name [ STARTLINE command-string ]

Usage 

The START ENGINE statement starts a database server. If you wish to specify a set of options for the server, use the STARTLINE keyword together with a command string. Valid command strings are those that conform to the database server description in The database server.

Permissions 

None

Side effects 

None

See also 

STOP ENGINE statement

The database server

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not applicable.

Example 

Start a database server, named sample, without starting any databases on it.

START ENGINE AS sample

The following example shows the use of a STARTLINE clause.

START ENGINE AS eng1 STARTLINE 'dbeng9 -c 8M'