MIMLOAD

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"

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.

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.

Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se