NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
D-72
Considerations—DUP
INDEX[ES] [ IMPLICIT | OFF ]
specifies whether to duplicate indexes of duplicated tables:
The default is INDEXES IMPLICIT.
VIEW[S] [ IMPLICIT | EXPLICIT | OFF ]
specifies whether to duplicate views of duplicated tables:
The default is VIEWS IMPLICIT.
An error occurs if you specify VIEWS IMPLICIT, either explicitly or by default,
and the source-fileset-list includes only some of the tables underlying a
shorthand view.
Considerations—DUP
•
Authorization requirements
DUP requires authority to read the objects and files being duplicated, authority to
read catalogs in which the objects are described, authority to write to the catalogs in
which new objects are to be described, authority to write to any files created, and
authority to purge any objects or files that must be purged.
•
Rules for objects and files
DUP creates objects and files that have the same physical attributes as the original
objects and files. In addition, DUP enforces the following rules for various types of
objects and files:
Rules for all SQL objects
•
If the catalog you specify to hold the description of a new object does not exist,
DUP does not duplicate the object. Depending on the setting of
ALLOWERRORS, this condition might cause the DUP operation to fail.
•
Any comments on a source object recorded in the COMMENTS table of the
original catalog are applied to the new object and recorded in the COMMENTS
table of the new catalog.
Rules for tables
•
target-fileset or the MAP NAME option you specify must include
sufficient information to allow DUP to map names of any partitions, views, or
IMPLICIT Duplicate indexes of duplicated tables
OFF Do not duplicate indexes of duplicated tables
IMPLICIT Duplicate a view only if one of its underlying tables is duplicated
EXPLICIT Duplicate views only if the view names are in source-fileset-
list, not merely because one of the underlying tables is duplicated.
OFF Do not duplicate views.