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

Note: 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