SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-7
Syntax Description of DUP
constraints and are duplicated if you specify CONSTRAINTS ON. NOT
DROPPABLE constraints are always duplicated.
ON
duplicates all DROPPABLE unique, not null, primary key, and check
constraints. The default is ON.
If the source table has unique or droppable primary key constraints, the
INDEX option must be set to ON, otherwise DUP returns an error.
constraint-list
is a list of constraint-maps.
constraint-map
specifies the target constraint name. If you do not specify
constraint-map, DUP uses a generated name based on the target
table name for each constraint.
source-constraint
is the constraint to be duplicated, including unique, not null, primary key,
and check constraints.
target-constraint
is the constraint that is formed after the DUP operation. If you specify
constraint-map, target-constraint is required.
OFF
does not copy constraints. If indexes is ON, only user-created indexes
are copied.
log-clause
specifies logging functionality to the DUP function and starts logging to a disk
file. While logging is in progress, the DUP commands that are entered are
executed and written to the disk file. The output of the DUP command is also
written to the disk file.
OUTFILE oss-file [CLEAR]
specifies that the output go to a disk file. oss-file is the path name of
the file to which DUP writes commands and command output. CLEAR
clears the oss-file before logging begins. If CLEAR is omitted,
OUTFILE appends the new log to existing data in oss-file.
oss-file cannot contain the “,” (comma) character or the “;” (semicolon)
character.