Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


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 \ when UNIX-style switches are used. For VMS-style switches, a double quote " is used as escape 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
VMS-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.
Note: The password is case sensitive. Enclose in double quotes if necessary.
 -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' log stderr"
VMS-style
 MIMLOAD /USER=USER1 /PASSWORD=user1_psw "LOAD FROM 'STORE.SQL' LOG STDERR"

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"
VMS-style
 MIMLOAD /DATABASE=STORE /USER=STORE_ADM /PASSWORD=store_psw "UNLOAD TO 
'STORE.SQL' FROM CURRENT USER"

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