Programming Guide

Uses a named database engine for the duration of a statement

DBMS WITH ENGINE engine command...

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.

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 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.

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

ENGINE, dm_is_engine

---

---