Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


The EXLOAD program


By using the EXLOAD program the example environment can be created or removed. (The example environment can also be removed by dropping the MIMER_STORE ident from any SQL command tool).

At installation of the example environment, default values are provided for passwords and for databank file names. These default values can be changed by using the ALTER command after the installation is completed or by explicitly giving passwords and filenames as command line arguments to the EXLOAD command, see the syntax below.

Syntax

The EXLOAD syntax (expressed in Unix-style) is as follows:
 usage: exload [-s|-m] [-f|-r] [-p SYSADM-password] [database]
 
 -s: single, single-user mode database access
 -m: multi, multi-user mode database access
 -f: force, drop if already exists
 -r: remove, drop if exists
 
 When creating the example database it is possible to change the default
 values for passwords and filenames. This is done by adding new values
 after the 'database' parameter (that must be given in this case).
 These optional parameters must be added in the following order:
 
 
 [MIMER_STORE-password
 [MIMER_ADM-password
 [MIMER_USR-password
 [MIMER_WEB-password
 [MIMER_STORE-db-filename
 [MIMER_ORDERS-db-filename
 [MIMER_BLOBS-db-filename]]]]]]]

Command-line Arguments

UNIX-style
VMS-style
Function
-s
/SINGLE
Single-user mode database access
-m
/MULTI
Multi-user mode database access
-r
/REMOVE
Remove the example database
-f
/FORCE
Install the example database even if it already exists. The old environment is dropped.
-p SYSADM-password
/PASSWORD=
SYSADM-password
Password for SYSADM
database
database
Database name
MIMER_STORE-password
MIMER_STORE-password
Password for MIMER_STORE ident
MIMER_ADM-password
MIMER_ADM-password
Password for MIMER_ADM ident
MIMER_USR-password
MIMER_USR-password
Password for MIMER_USR ident
MIMER_WEB-password
MIMER_WEB-password
Password for MIMER_WEB ident
MIMER_STORE-db-filename
MIMER_STORE-db-filename
Filename for MIMER_STORE databank
MIMER_ORDERS-db-filename
MIMER_ORDERS-db-filename
Filename for MIMER_ORDERS databank
MIMER_BLOBS-db-filename
MIMER_BLOBS-db-filename
Filename for MIMER_BLOBS databank

All parameters to EXLOAD are optional. If no command line arguments are given, the following will happen:

Exit Codes

The EXLOAD program returns an error status to the operating system when an error is encountered. This may be useful when running EXLOAD from scripts or in batch mode.

The following error codes are used:

UNIX/Windows
OpenVMS
Usage
 0 (success)
 1 (success)
This code is used when EXLOAD has executed successfully.
 >1 (error)
 2 (error)
This error code is used when EXLOAD failed to execute successfully.


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX