IMPORT SCHEMA ─┬──────────────────────────┬─> 
F
R
O
M file-spec ─┐
                └─> 
A
U
T
H
O
R
I
Z
A
T
I
O
N auth-id ─┘                   │
 ┌─────────────────────────────────────────────────────────────┘
 └┬─┬──────────────────────────────────┬─┬─> typebox (;)
  │ ├┬───────┬─┬─> 
A
C
L ──────────┬─────┤ │
  │ │└─> 
N
O ─┘ ├─> 
B
A
T
C
H 
U
P
D
A
T
E ─┤     │ │
  │ │          └─> 
C
D
D 
L
I
N
K
S ────┘     │ │
  │ ├─> root-file-params ──────────────┤ │
  │ ├─> storage-area-params ───────────┤ │
  │ ├─> create-storage-area-clause ────┤ │
  │ ├─> create-storage-map-statement ──┤ │
  │ ├─> create-index-statement ────────┤ │
  │ ├─> drop-storage-area-statement ───┤ │
  │ ├─> drop-storage-map-statement ────┤ │
  │ └─> drop-index-statement ──────────┘ │
  └───────────────── <───────────────────┘

Additional information available:

ACLBATCH_UPDATECDD_LINKS

More Informationroot file paramsstorage area params

 ACL is the default and specifies that IMPORT uses the the access
 control lists from the original database when it create the new
 database.  If you are using IMPORT to restructure a database,
 you typically want to use ACL and preserve the access control
 lists.

 NO ACL overrides the ACLs from the original database and uses
 the database system default ACLs.  Specify NO ACL if you are
 using IMPORT to rebuild a database on a different system or to
 convert to an Rdb/VMS database from another DSRI-compliant
 database system.  NO ACL makes you the owner of the new database
 and creates default access control lists.

 Specifies whether IMPORT stores user data and indexes in a
 single BATCH UPDATE transaction mode or in in separate READ
 WRITE transactions for each table (NO BATCH UPDATE).  By default
 IMPORT stores user data and indexes in a single BATCH UPDATE
 transaction.

 BATCH UPDATE mode is faster but does not perform run-unit
 journaling, which means you cannot recover the database in the
 event of a failure during the IMPORT operation.  With the NO
 BATCH UPDATE option, you can recover the database.

 Determines whether IMPORT tries to reestablish links between
 schema definitions originally based on data dictionary
 definitions (domains and tables created with the FROM pathname
 clause) and their sources in the data dictionary.

 The default depends on whether the IMPORT statement specifies
 PATHNAME.  If IMPORT does specify PATHNAME, CDD LINKS is the
 default; if it does not specify PATHNAME, NO CDD LINKS is the
 default.

 CDD LINKS specifies that IMPORT does try to reestablish data
 dictionary links even if you do not specify PATHNAME.  If you
 specify CDD LINKS and the database dictionary definition on
 which a schema definition was based no longer exists, IMPORT
 generates a warning message.

 NO CDD LINKS specifies that IMPORT does not establish data
 dictionary links even if you specify PATHNAME.  Specify NO CDD
 LINKS if you are using IMPORT to rebuild a database on a
 different system or to convert to an Rdb/VMS database from
 another DSRI-compliant database system.

 Creates an Rdb/VMS database from an intermediate, compressed
 .RBR file.

 You use IMPORT with EXPORT 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:

      -  BUFFER SIZE

      -  SEGMENTED STRING STORAGE AREA


  o  Change storage area parameters you cannot change with ALTER
     SCHEMA:

      -  ALLOCATION

      -  PAGE SIZE

      -  PAGE FORMAT

      -  THRESHOLDS

      -  INTERVAL

      -  SNAPSHOT FILENAME

      -  Any characteristics of the RDB$SYSTEM storage area


  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  Move a database to another directory or disk structure

  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.

 root-file-params =
 ────┬─┬──────────────────────────> ───────────────────────────────┬─┬──>
     │ ├─> 
F
I
L
E
N
A
M
E file-spec ─────────────────────────────────────┤ │
     │ ├─> 
P
A
T
H
N
A
M
E path-name ─────────────────────────────────────┤ │
     │ ├─> 
D
B
K
E
Y 
S
C
O
P
E typebox (I)typebox (S) ─┬─> 
T
R
A
N
S
A
C
T
I
O
N ─┬──────────────────────┤ │
     │ │                   └─> 
A
T
T
A
C
H ──────┘                      │ │
     │ ├─> 
N
U
M
B
E
R typebox (O)F 
U
S
E
R
S typebox (I)typebox (S) ──> number-users ────────────────────┤ │
     │ ├─> 
N
U
M
B
E
R typebox (O)F 
B
U
F
F
E
R
S typebox (I)typebox (S) ─────> number-buffers ─────────────┤ │
     │ ├─> 
N
U
M
B
E
R typebox (O)F 
V
A
X
C
L
U
S
T
E
R 
N
O
D
E
S typebox (I)typebox (S) ──> number-nodes ─────────┤ │
     │ ├─> 
N
U
M
B
E
R typebox (O)F 
R
E
C
O
V
E
R
Y 
B
U
F
F
E
R
S typebox (I)typebox (S) ───> number-buffers ──────┤ │
     │ ├─> 
B
U
F
F
E
R 
S
I
Z
E typebox (I)typebox (S) ─────> buffer-blocks ──> 
B
L
O
C
K
S─────────┤ │
     │ ├─> 
S
N
A
P
S
H
O
T typebox (I)typebox (S) ────┬─────> 
E
N
A
B
L
E
D ─┬─>  
I
M
M
E
D
I
A
T
E  ──┬─┬──┤ │
     │ │                   │                └─>  
D
E
F
E
R
R
E
D ────┘ │  │ │
     │ │                   └─────> 
D
I
S
A
B
L
E
D ───────────>────────┘  │ │
     │ ├─> 
D
I
C
T
I
O
N
A
R
Y typebox (I)typebox (S) ───┬───> 
R
E
Q
U
I
R
E
D ───────┬────────────────┤ │
     │ │                    └───> 
N
O
T 
R
E
Q
U
I
R
E
D ───┘                │ │
     │ ├─> 
A
D
J
U
S
T
A
B
L
E 
L
O
C
K 
G
R
A
N
U
L
A
R
I
T
Y typebox (I)typebox (S) ─┬─> 
E
N
A
B
L
E
D ──┬─────────┤ │
     │ │                                   └─> 
D
I
S
A
B
L
E
D ─┘         │ │
     │ └─> 
S
E
G
M
E
N
T
E
D 
S
T
R
I
N
G typebox (S)typebox (T)typebox (O)typebox (R)typebox (A)typebox (G)typebox (E) 
A
R
E
A typebox (I)typebox (S) area-name ─────────────┘ │
     └────────────────────────────── <───────────────────────────────┘

Additional information available:

More Information

 Parameters that control the characteristics of the database root
 file associated with the schema, or characteristics stored in
 the root file that apply to the entire database.

 storage-area-params =

 ─┬─┬──────────────────────────>─────────────────────────────┬─┬──>
  │ ├─> 
A
L
L
O
C
A
T
I
O
N typebox (I)typebox (S) ───> number-pages ────> typebox (P)typebox (A)typebox (G)typebox (E)typebox (S) ─────────┤ │
  │ ├─> 
P
A
G
E 
S
I
Z
E typebox (I)typebox (S) ────> page-blocks ─────> typebox (B)typebox (L)typebox (O)typebox (C)typebox (K)typebox (S) ────────┤ │
  │ ├─> 
P
A
G
E 
F
O
R
M
A
T typebox (I)typebox (S) ──┬────> 
U
N
I
F
O
R
M ────┬────────────────┤ │
  │ │                    └────> 
M
I
X
E
D ──────┘                │ │
  │ ├─> 
T
H
R
E
S
H
O
L
D
S typebox (A)typebox (R)typebox (E) ( val1 ─┬──────────────────────┬─> ) ─┤ │
  │ │                          └─> ,val2 ─┬──────────┬┘      │ │
  │ │                                     └─> ,val3 ─┘       │ │
  │ ├─> 
I
N
T
E
R
V
A
L typebox (I)typebox (S) ───────> number-data-pages ──────────────┤ │
  │ ├─> 
E
X
T
E
N
T typebox (I)typebox (S) ────┬──> extent-pages ────> typebox (P)typebox (A)typebox (G)typebox (E)typebox (S) ────┬────┤ │
  │ │                 └──> (extension-options)──────────┘    │ │
  │ ├─> 
S
N
A
P
S
H
O
T 
F
I
L
E
N
A
M
E ───> file-spec ────────────────────┤ │
  │ ├─> 
S
N
A
P
S
H
O
T 
A
L
L
O
C
A
T
I
O
N typebox (I)typebox (S) ──> snp-pages ──> typebox (P)typebox (A)typebox (G)typebox (E)typebox (S) ──────┤ │
  │ └─> 
S
N
A
P
S
H
O
T 
E
X
T
E
N
T typebox (I)typebox (S) ─┬─> extent-pages ──> typebox (P)typebox (A)typebox (G)typebox (E)typebox (S) ─┬────┘ │
  │                         └─> (extension-options) ────┘      │
  └─────────────<─────────────────────────────────────<────────┘

Additional information available:

More Information

 Parameters that control the characteristics of database storage
 area files.  You can specify most storage area parameters for
 either single-file or multifile databases, but the effect of the
 clauses differs:

  o  For single file databases, the storage area parameters
     specify the characteristics for the single storage area in
     the schema

  o  For multifile databases, the storage area parameters specify
     a set of default values for any storage areas created by the
     CREATE SCHEMA statement that do not specify their own values
     for the same parameters.  The default values apply to the
     RDB$SYSTEM storage area, plus any others named in CREATE
     STORAGE AREA schema elements.

     CREATE STORAGE AREA statements can override these default
     values, and the default values do not apply to CREATE
     STORAGE AREA statements outside the scope of the CREATE
     SCHEMA statement.