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

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 SYSADMpwd
 --password=SYSADMpwd
 /PASSWORD=SYSADMpwd
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.

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.

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