START ENGINE Statement [Interactive SQL]

Starts a database server.

Syntax

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

Examples

Example 1 – Start a database server named eng1 without starting any databases on it:
```
START ENGINE AS eng1
```

Example 2 – Use of the STARTLINE clause:

START ENGINE AS eng1 STARTLINE 'start_iq -c 8096'

Usage

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

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

Standards

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

Permissions

None