Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Related Articles

AUTHORIZATION

FILENAME

PATHNAME

WITH_EXTENSIONS

INTO file-spec

More Information

RDB/VMS SQL EXPORT — VMS RDB_3.1A

 EXPORT SCHEMA ─┬─> 
A

U

T

H

O

R

I

Z

A

T

I

O

N
auth-id ─┬─┐ ├─> 
F

I

L

E

N

A

M

E
file-spec ────┤ │ └─> 
P

A

T

H

N

A

M

E
path-name ────┘ │ ┌───────────────────────────────────────────┘ └─> 
I

N

T

O
file-spec ─┬───────────────────────────┬─> typebox (;) └─ 
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:

AUTHORIZATIONFILENAMEPATHNAMEWITH_EXTENSIONS

INTO file-specMore Information

AUTHORIZATION

 Specifies the source database files to be compressed and written
 to an .RBR file.

 AUTHORIZATION specifies the authorization identifier of an
 already-declared schema.  If the schema you want to export is
 already declared, specifying AUTHORIZATION avoids the overhead
 of a second attachment to the schema and the locking that
 attachment entails.

FILENAME

 Specifies the source database files to be compressed and written
 to an .RBR file.

 FILENAME and PATHNAME both identify the database root file
 associated with the schema.  If you specify a data dictionary
 path name, the pathname indirectly specifies the root file.
 EXPORT does not change any definitions in the data dictionary,
 so there is no difference in the effect of the PATHNAME and
 FILENAME arguments.

INTO file-spec

 Specifies the name for the .RBR file EXPORT creates.
 Optionally, the file specification can include a device and
 directory specification.

More Information

 Makes a copy of a database in an intermediate, compressed form.
 Use the IMPORT statement to rebuild an Rdb/VMS database from the
 compressed .RBR file created by EXPORT.

 You use EXPORT with IMPORT to make changes to Rdb/VMS databases
 that cannot be made any other way.  EXPORT unloads a database to
 an .RBR file.  IMPORT recreates the database with changes not
 allowed through ALTER statements:

  o  Convert a single-file database to multifile and vice versa

  o  Change root file parameters you cannot change with ALTER
     SCHEMA:

  o  Change storage area parameters you cannot change with ALTER
     SCHEMA

  o  Reload tables with existing rows to take advantage of
     newly-created hashed indexes

  o  Reload tables to take advantage of new or changed storage
     maps

  o  Convert a database from another DSRI-compliant
     implementation to an Rdb/VMS database.  For instance, the
     Rdb/ELN EBRP utility creates an .RBR file you can use with
     the IMPORT statement to create an Rdb/VMS database.

PATHNAME

 Specifies the source database files to be compressed and written
 to an .RBR file.

 FILENAME and PATHNAME both identify the database root file
 associated with the schema.  If you specify a data dictionary
 path name, the pathname indirectly specifies the root file.
 EXPORT does not change any definitions in the data dictionary,
 so there is no difference in the effect of the PATHNAME and
 FILENAME arguments.

WITH_EXTENSIONS

 Specifies whether the .RBR file created by the EXPORT statement
 includes extensions that are compatible only with Rdb/VMS
 Version 3.0 or later database systems.  WITH EXTENSIONS is the
 default.

 The only time you need to specify WITH NOEXTENSIONS is if the
 database system through which you will rebuild the .RBR file
 into a database is:

  o  Rdb/VMS Version 2.3 or earlier

  o  Any verson of Rdb/ELN

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