WITH ENGINE

Uses a named database engine for the duration of a statement

Synopsis

DBMS WITH ENGINE engine command...

Arguments

WITH ENGINE
Name of engine to associate with the command. If the clause is not specified, Panther uses the default engine.

engine
Mnemonic associated with the engine when you make your Panther executables. Colon expansion of the engine name is allowed.

command
Text of the DBMS command.

Description

The DBMS WITH ENGINE clause specifies which database engine Panther should use when executing a command. If only one database engine is initialized, that engine is automatically the default. An application using two or more engines can set the default engine with the DBMS ENGINE command.

The following commands accept an optional WITH ENGINE clause:

DBMS WITH ENGINE engine DECLARE connection CONNECTION ... 
DBMS WITH ENGINE engine CLOSE_ALL_CONNECTIONS

Once a connection is declared, it remains associated with the database engine on which it was declared. After declaring the connection, the WITH ENGINE clause is no longer necessary or valid in any statement except for DBMS CLOSE_ALL_CONNECTIONS which allows you to close the connections for the default or named engine.

Example

Refer to "Connecting to Multiple Engines" on page 8-5 in Application Development Guide.

See Also

ENGINE, dm_is_engine