<MvDBCOMMAND>

The database must already be open or created via the <MvOPEN> or <MvCREATE> tags.

Attributes

• NAME: Optional Database alias. When a database is opened with <MvOPEN>, it is referenced in all other database commands by the alias. If  omitted, the index is opened for the primary database. The database must be open.
• COMMAND: Required. Command name.
• PARAMETER: Optional parameters.

All database interfaces take these commands:

• Command: log: Log interface-specific details to a log file. Parameter: If specified, the name of the file to log to in the data directory.

The MySQL interface takes these commands:

• Command: manualcommit. Set the database connection to not automatically execute a commit after every statement. Parameter: None.
• Command: autocommit.  Reset the database connection to automatically execute a commit after every statement. Parameter: None.

The MivaSQL interface takes this command:

• Command: subdir_char. The MivaSQL database create tables and indices with this character converted to a directory boundary. The MivaSQL database will also manage the subdirectories that it creates. Parameter: The character to use (i.e. "_" ).

The query below, "CREATE TABLE S01_MMUI_STORESELECTION" will create a data file called  s01/mmui/storeselection.dbf and the subdirectories. The underscore character "_" is specified as the subdir_char.

<MvOPEN NAME = "Merchant"
        DATABASE = "{ l.database }"
        USERNAME = "{ l.username }"
        PASSWORD = "{ l.password }"
        TYPE = "mivasql">
<MvDBCOMMAND NAME = "Merchant" COMMAND = "subdir_char" PARAMETER = "_">

<MvQUERY NAME="Merchant" QUERY = "{ 'CREATE TABLE S01_MMUI_STORESELECTION ( ... field list ... )' }">