Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Related Articles

More

Format

Example

WITH

database-file-spec

interchange-file-spec

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:

MoreFormatExample

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:

WITH

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.

Typewritten Software • bear@typewritten.org • Edmonds, WA 98026