Reference Manual
   CHAPTER 9. SQL Statements     

START ENGINE statement [ISQL]

Function 

To start a database server.

Syntax 

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

Permissions 

The required permissions are specified by the database server -gk command-line option. This option defaults to none on the personal database server, and dba on the network server.

Side effects 

None

See also 

STOP ENGINE statement

The database server

Description 

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 command-line description in The database server.

Standards and compatibility 

• SQL/92     Vendor extension.

• Sybase     Not applicable.

Example 

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

  START ENGINE AS sample ;

• Start a Windows 3.x personal server with a maximum cache size of 4 megabytes, loading the sample database.

  START ENGINE AS sample
  STARTLINE 'dbeng6w -c 4096 path\asademo.db'

• The following example shows the use of a STARTLINE clause.

  START ENGINE AS eng1 STARTLINE 'dbeng6 -c 8096'