START ENGINE Statement [Interactive SQL]

Quick Links:

Syntax

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

Parameters

(back to top)

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. See start_iq Database Server Startup Utility in the Utility Guide.

Examples

(back to top)

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

(back to top)

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 SAP Control Center or a configuration file with the start_iq command.

Standards

(back to top)

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

Permissions

(back to top)

None