START ENGINE Statement [Interactive SQL]

Syntax

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

Parameters

STARTLINE – to specify a set of options for the server.

command-string – valid command strings are those that conform to the database server command line description per the Utility GuideUtility Guide, under start_iq Database Server Startup Utility.

Examples

Example 1 – starts a database server named eng1 without starting any databases on it:
```
START ENGINE AS eng1
```
Example 2 – starts the same server with a cache of 8096KB:
```
START ENGINE AS eng1 STARTLINE 'start_iq -c 8096'
```

Usage

Several server options are required for SAP Sybase IQ to operate well. To ensure that you are using the right set of options, start your server by using either Sybase Control Center or a configuration file with the start_iq command.

Standards

SQL—Vendor extension to ISO/ANSI SQL grammar.
Sybase—Not applicable.

Permissions

None