http://developer.mimer.com

Creating Databanks

---

A databank is the physical 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 specification is machine-specific). 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 stored in the file called 'mimer_blobs.dbf':

Note: The default parameters are with TRANS option and size 1000 Mimer pages.

 CREATE DATABANK mimer_blobs;

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

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

At this point, the databank is empty.

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se