Mimer SQL User's Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


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 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 GUESTDB with the default parameters stored in the file called 'guestdb':
Note: The default parameters are: with TRANS option and size 1000 Mimer pages.
 CREATE DATABANK GUESTDB;
Create the ROOMSDB databank with LOG option, allocate 200 Mimer pages for it, and store it in a file call 'rooms.dbnk':
 CREATE DATABANK ROOMSDB
        OF 200 PAGES
        IN 'ROOMS.DBNK'
        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
Mimer SQL User's Manual TOC PREV NEXT INDEX