EXLOAD - Creating the example database

---

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

When the example database is installed default values are provided for passwords on idents and for databank file names. These default values can be changed by using the ALTER command after the installation is completed or by explicitly give names as command line arguments to the exload command, see the exload syntax below.

Syntax

The exload syntax (expressed in short form 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          Forced install (overwrites existing environment)
        -r, --remove         Remove the example environment
        -p passw, --password=passw
                             Password for SYSADM
        database   Name of database to access
 
        When creating the example database it is possible to change the default
        values for passwords and filenames. This is done by adding parameters
        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-databank-filename
        [MIMER_ORDERS-databank-filename
        [MIMER_BLOBS-databank-filename]]]]]]]
 

All parameters to exload are optional.

Command-line Arguments

UNIX-style	VMS-style	Function
-s --single	/SINGLE	Single-user mode database access
-m --multi	/MULTI	Multi-user mode database access
-r --remove	/REMOVE	Remove the example database
-f --force	/FORCE	Install the example database even if it already exists. The old environment is dropped.
-p SYSADM-pwd --password=SYSADMpassword	/PASSWORD=SYSADMpassword	Password for SYSADM
database	database	Database name
MIMER_STOREpwd	MIMER_STOREpwd	Password for MIMER_STORE ident
MIMER_ADMpwd	MIMER_ADMpwd	Password for MIMER_ADM ident
MIMER_USRpwd	MIMER_USRpwd	Password for MIMER_USR ident
MIMER_WEBpwd	MIMER_WEBpwd	Password for MIMER_WEB ident
MIMER_STOREdbfilename	MIMER_STOREdbfilename	Filename for MIMER_STORE databank
MIMER_ORDERSdbfilename	MIMER_ORDERSdbfilename	Filename for MIMER_ORDERS databank
MIMER_BLOBSdbfilename	MIMER_BLOBSdbfilename	Filename for MIMER_BLOBS databank
-? --help	/HELP	Show help text.

If no command line arguments are given when using exload, 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 already is installed a question about how to continue will be raised.
• Default values are used for all example database passwords and filenames. The values used are displayed when the exload program is executed.

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se