SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-4
DUP Utility
DUP Utility
Syntax Description of DUP
Considerations for DUP
DUP is a syntax-based utility that can be executed through MXCI. The DUP utility
copies SQL/MX tables and optionally their indexes and constraints.
DUP source-target-list [ mapping ][,dup-option
[, dup-option]...]
source-target-list is:
{ source-table TO target-table }
source-table is:
[[catalog].schema.]object
target-table is:
[{catalog | *}.{schema | *}.]object
mapping is:
{ LOCATION (volume-map) [, volume-map ] ...) }
volume-map is:
[PART] [\node.]volume TO [\node.] $volume
dup-option is:
{ TARGET { NEW | PURGE }
| INDEX[ES] [ { [ON] | OFF | [ON] (index-list )}]
| CONSTRAINT[S] [{[ON] (constraint-list) | OFF | ON}]
| OUTFILE oss-file [CLEAR] }
index-list is:
index-map [, index-map] ...
index-map is:
source-index TO target-index [mapping]
constraint-list is:
constraint-map [, constraint-map] ...
constraint-map is:
source-constraint TO target-constraint
source-index is: object
target-index is: object
source-constraint is: object
target-constraint is: object