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.
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