Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


MIMLOAD


MIMLOAD enable you to use the LOAD and UNLOAD commands at your operating system's command prompt.

Syntax

You control MIMLOAD using flagged information specified on the command-line.

The overall syntax for MIMLOAD (expressed in UNIX-style) is:

 mimload [-d database] [-u user] [-p password] [-e program password] "statement"
 
Note: If you are using double quotes in the LOAD/UNLOAD statement, they must be escaped using the back-slash character \.

If you start MIMLOAD command without specifying options, it displays help on the command-line arguments.

Command-line Arguments

You can use the following arguments with MIMLOAD.

UNIX/Windows-style
OpenVMS-style
Function
 -d database
 /DATABASE database
Specifies the name of the database to access.
If you do not specify a database name, the default database will be used.
 -u user
 /USER user
Specifies the user to be used.
If you do not specify a user, OS_USER is assumed.
 -p password
 /PASSWORD password
Specifies the password for the user.
If you are using OS_USER, a password is not needed.
 -e program password
 /ENTER program password
Specifies an optional ENTER ident, with password, to be used in the connection phase.
This argument can be specified more than one time and thus allows entering deeper entry levels.
 "statement"
 "statement"
Specifies the LOAD/UNLOAD statement. Enclose in double quotes.

Exit Codes

The following error codes are used:

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

Examples

Loading Data

The following example loads the file store.sql into the default database.

UNIX/Windows-style
 mimload -u user1 -p user1_psw "load from 'store.sql'"
OpenVMS-style
 MIMLOAD /USER USER1 /PASSWORD user1_psw "LOAD FROM 'STORE.SQL'"

Unloading Data

'The following example unloads all the definitions and data owned by the user store_adm from the database store to the file store.sql.

UNIX/Windows-style
 mimload -d store -u store_adm -p store_psw "unload to 'store.sql'
 from current user" 
OpenVMS-style
 MIMLOAD /DATABASE STORE /USER STORE_ADM /PASSWORD store_psw "UNLOAD TO 'STORE.SQL' FROM CURRENT USER"


Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX