User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To start a database engine

Syntax

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

Usage

ISQL

Permissions

None

Side effects

None

See also

• STOP ENGINE statement
• "The database engine"

Description

The START ENGINE statement starts a database engine. If you wish to specify a set of options for the engine, use the STARTLINE keyword together with a command string. Valid command strings are those that conform to the database engine command-line description in the chapter "SQL Anywhere Components".

Example

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

     START ENGINE AS sample ;

Start a database engine with a maximum cache size of 4 megabytes, loading the sample database.

     START ENGINE AS sample
     STARTLINE 'dbeng50w -c 4096 c:\sqlany50\sademo.db'

The following example shows the use of a STARTLINE clause.

     START ENGINE AS eng1 STARTLINE 'dbeng50 -c 8096'