SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-72
DUP Command
{ collation-name }
{ }
{ ( collation-name [ , collation-name ] ... )}
FOR simple-fileset-list
collation-name identifies a collation and FOR simple-fileset-list
specifies a simple fileset list that includes the names of any new objects that
reference the collation.
The first collation specified whose simple name matches the simple name of a
collation referenced in the new object being created is mapped to the new
object. If the new object is referenced in more than one specified fileset, the
first fileset specified is used. If no collation names match, or if no specified
fileset contains the new object, no mapping occurs.
If you omit the COLLATION option, a new object that uses a collation references
the same collation referenced by the original object.
ALLOWERRORS [ON | OFF | num]
specifies error handling:
If you omit the ALLOWERRORS clause completely, the default is
ALLOWERRORS OFF. If you specify ALLOWERRORS but do not specify an
option, the default is ALLOWERRORS ON.
[ NO ] LISTALL
specifies whether to display the name of each duplicated file or object in this
format:
DUPLICATED object-type source-name TO target-name
PARTS (part-num,src-$volume TO tgt-$volume,
...
)
object-type is TABLE, INDEX, COLLATION, PVIEW, SVIEW, or FILE.
Dependent objects that are duplicated automatically when the underlying object is
duplicated are listed below the underlying object. The PARTS clause appears only
for partitioned files, tables, and indexes.
ON attempts to duplicate all specified files, regardless how many errors are
encountered
OFF stops the DUP operation after the first error is encountered
num duplicates all specified objects and files until the number of errors
encountered exceeds the value of num