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':