RDB/VMS Relational Database Operator EXPORT — VMS CDD+_4.1A
Makes a copy of a database in an intermediate, compressed form. Use
the RDO IMPORT statement on this export file to rebuild the Rdb/VMS
database.
Example:
RDO> EXPORT 'DEPT3:PERS' INTO 'DISK2:PERSONNEL.RBR'
Additional information available:
More
Use EXPORT and IMPORT to:
o Restructure a Rdb/VMS single-file database into a multifile
database
o Restructure a multifile database
o Migrate a database from one DSRI-compliant database management
system to another
o Create a version-independent copy of the database for archiving
purposes
o Change database and storage area characteristics that you cannot
change with the CHANGE DATABASE statement
The IMPORT and EXPORT statements are not intended for regular backups
of the database. For regular backups and restorations of Rdb/VMS
databases, use the RMU/BACKUP and RMU/RESTORE commands.
Format
EXPORT ─────> database-file-spec ───> typebox (I)typebox (N)typebox (T)typebox (O) ───> interchange-file-spec ───┐ ┌────────────────────────────────────────────────────────────────────────┘ │ └───────┬─────────────────────────────────────────┬───────> └────>
W
I
T
H ─────┬───>
E
X
T
E
N
S
I
O
N
S ───────┤ └───>
N
O
E
X
T
E
N
S
I
O
N
S ─────┘
Additional information available:
database-file-specinterchange-file-spec
database-file-spec
The file specification for the database you want to back up. Use either a full or partial file specification or a logical name. If you use a simple file name, Rdb/VMS looks for the database in the current default directory. If you do not specify a file type, Rdb/VMS uses RDB.
interchange-file-spec
The file specification for a file in which EXPORT places an intermediate version of the database. Use either a full or partial file specification or a logical name. If you use a simple file name, Rdb/VMS places the interchange file in the current default directory. The default file type is RBR.
WITH
Specifies that the exported format of the database be compatible with a pre-V3.0 Rdb/VMS database (WITH NOEXTENSIONS), or with an Rdb/VMS database created with the current software (WITH EXTENSIONS). The default is WITH EXTENSIONS. WITH EXTENSIONS also directs Rdb/VMS to preserve other parameters about the physical structure of the exported database.
Example
Example 1 The following example shows how to export a database to a disk file: RDO> EXPORT cont> 'DEPT3:PERSONNEL.RDB' INTO cont> 'EXPORT$DISK:[EXPORT]PERSONNEL.RBR' This statement creates an interchange file for the PERSONNEL database from the database file identified by DEPT3:PERSONNEL.RDB. DEPT3 in this case is a logical name for the device and directory where the database is located. The copy is stored on EXPORT$DISK in the directory [EXPORT]. By default, the database is exported WITH EXTENSIONS. Example 2 The following example shows how to export a database to a magnetic tape volume: $ INITIALIZE MUA0: _Label: PERS $ $ MOUNT MUA0: _Label: PERS _Log name: $ RDO RDO> EXPORT 'DEPT3:PERSONNEL.RDB' INTO 'MUA0:PERSONNEL.RBR' This statement creates an intermediate copy of the database on the magnetic tape volume labeled PERS, mounted on device MUA0:. Example 3 The following example shows how to use the EXPORT statement to migrate an Rdb/VMS multifile database to an Rdb/ELN system. RDO> EXPORT 'MF_PERS.RDB' INTO 'ELN_PERS.RBR' WITH NOEXTENSIONS Because Rdb/ELN must see the the migrated database as a pre-V3.0 database, you must use the NOEXTENSIONS option.