START ENGINE statement [DBISQL]

Description

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

The following example shows the use of a STARTLINE clause.

START ENGINE AS eng1 STARTLINE 'start_asiq -c 8096'

Usage

The START ENGINE statement starts a database server. If you wish 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 Chapter 1, “Running the Database Server” in the Sybase IQ Utility Guide.

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

Side effects

None

Standards

SQL/92 Vendor extension.

Sybase Not applicable.

Permissions