SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-73
DUP Command
If you omit the LISTALL option, LISTALL is the default. If you specify NO LISTALL,
DUP suppresses the display of confirmations.
SAVEALL [ ON | OFF ]
specifies a setting for both the SAVEID and the SOURCEDATE options.
If you specify SAVEALL and specify either SAVEID or SOURCEDATE separately,
the settings must match.
The default is SAVEALL OFF.
SAVEID [ ON | OFF ]
specifies the security and owner for new objects and files:
The default is SAVEID OFF.
SOURCEDATE [ ON | OFF ]
controls the timestamps of targets:
The default is SOURCEDATE OFF.
[ TARGET ] { NEW | KEEP | PURGE }
specifies what to do if a new item created by the DUP operation has the same
name as an existing object or file in the target location:
An error occurs if you specify TARGET PURGE and the one of the two items that
would have duplicate names is an SQL object and the other is an Enscribe file. An
error also occurs if you specify TARGET PURGE and the existing item is a
collation that has dependent objects.
ON Set SAVEID and SOURCEDATE to ON
OFF Set SAVEID and SOURCEDATE to OFF
ON Set security and owner of each new item to that of the corresponding
original item
OFF Set the security of each new item to the default security of the user who
executes DUP; make that user the owner
ON Assign each item the timestamps of the corresponding original item (for
tables: last modified, last opened, and most recently redefined; for
Enscribe files, only last modified timestamps)
OFF Assign each item timestamps for the date and time of the DUP operation
NEW Do not copy the item; report an error
KEEP Do not copy the item; do not report an error
PURGE Purge the object or file that has the same name as the new item, then
create the new item as specified in the DUP command