Sets or changes the default database engine
- Name of default database engine when two or more engines are initialized. engine is the mnemonic assigned to the database engine in the file
If an application initializes two or more database engines, the application can use
DBMS ENGINEto set a default engine. If an application has only one initialized engine, Panther automatically assigns that engine as the default.
For more information on initializing database engines, refer to Chapter 7, "Initializing the Database," in Application Development Guide.
// This procedure declares two connections,
// sets oracle to be the default engine, and
// then declares and executes a cursor on the
// default engine.proc entryDBMS WITH ENGINE oracle DECLARE c1 CONNECTION FOR \
USER ":user" PASSWORD ":pword"DBMS WITH ENGINE sybase DECLARE c2 CONNECTION FOR \
USER ":user" PASSWORD ":pword" SERVER "maple" \
DATABASE "sales"DBMS ENGINE oracleDBMS DECLARE t_cursor CURSOR FOR SELECT * FROM titlesDBMS WITH CURSOR t_cursor EXECUTEreturn
WITH ENGINE, dm_is_engine