SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-74
Considerations—DUP
The default is TARGET NEW.
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

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.

DUP creates objects and files that have the same physical attributes as the original
objects and files. In addition, DUP enforces these 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,
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.