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:

• A SYSADM password is needed and will be prompted for.
• Access mode and database name will be taken from MIMER_MODE and MIMER_DATABASE, respectively.
• If the example environment is already installed a question is prompted whether to continue or not
• Default values are used for all example database passwords and filenames. The values used are displayed when the EXLOAD program is executed.

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 Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se