SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-69
DUP Command
DUP Command
DUP is an SQLCI utility command that copies tables (optionally with the associated
views and indexes), views, collations, SQL programs in Guardian files, and Enscribe
files. DUP cannot copy a catalog table.
DUP is useful for moving tables to different nodes or volumes and for duplicating tables
for testing.
DUP resembles the FUP DUP command in function and syntax, but you cannot use
FUP DUP on SQL objects.
source-fileset-list
is a qualified fileset list that specifies the objects or files to duplicate. For
information, see Filesets on page F-29.
If source-fileset-list includes a primary partition, DUP duplicates all
partitions of the table or file, deriving names for new secondary partitions from the
values you specify for target-fileset or the MAP NAME option. If
source-file-list explicitly specifies a secondary partition, DUP reports an
DUP source-fileset-list,
{ target-fileset }
{ MAP NAME[S] { map-spec } }
{ { (map-spec [, map-spec] ... ) } }
[ [,] dup-option ] ... ;
dup-option is:
{ CATALOG[S] { catalog-spec } }
{ { ( catalog-spec [, catalog-spec ]...) } }
{ COLLATION[S] ( collation-spec[,collation-spec]... ) }
{ ALLOWERRORS [ ON | OFF | num ] }
{ [ NO ] LISTALL }
{ SAVEALL [ ON | OFF ] }
{ SAVEID [ ON | OFF] }
{ SOURCEDATE [ ON | OFF ] }
{ [ TARGET ] { NEW | KEEP | PURGE } }
{ INDEX[ES] [ IMPLICIT | OFF ] }
{ VIEW[S] [ IMPLICIT | EXPLICIT | OFF ] }
map-spec is:
simple-fileset-list TO fileset
catalog-spec is:
catalog-name [ FOR simple-fileset-list ]
collation-spec is:
{ collation-name }
{ ( collation-name [ , collation-name ] ... ) }
FOR simple-fileset-list