Creating Databanks

---

A databank is the file where a collection of tables is stored. A Mimer SQL database may contain any number of databanks.

Create Databank Statement

The statement for creating a databank has the general form:

 CREATE DATABANK databank-name
    [OF initial-size PAGES]
    [IN 'filename']
    [WITH transaction-control OPTION];
 

• The CREATE DATABANK clause defines the databank name.
• The optional OF clause allocates a specified number of Mimer pages. This sets the initial size of the file, it will be dynamically extended as space is required. If the OF clause is omitted, an initial file size of 1000 Mimer pages is assumed.
• The optional IN clause defines the file where the databank is to be stored (the form of the filename follows the operating system file naming conventions). If the IN clause is omitted, the file is created in the database home directory with the same name as databank-name.
• The optional WITH clause defines the transaction handling and logging option, see Logging Transactions. If the WITH clause is omitted, the TRANS option is assumed.

Examples

Create a databank called MIMER_BLOBS with the default parameters:

Note: The default parameters are with TRANS option and size 1000 Mimer pages. This databank is created in a file called 'mimer_blobs.dbf'

 CREATE DATABANK mimer_blobs;

Create the MIMER_STORE databank with LOG option, allocate 1200 Mimer pages for it, and store it in a file called 'mimer_store.dbf':

 CREATE DATABANK mimer_store OF 1200 PAGES IN 'mimer_store.dbf'
    WITH LOG OPTION;
 

At this point, the databank is empty.

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se