NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
D-71
DUP Command
SAVEALL [ ON | OFF ]
specifies a setting for both the SAVEID and the SOURCEDATE options.
If you specify SAVEALL and then 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 will have 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.
The default is TARGET NEW.
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