The following syntax is used to generate a statement for
each exported Delete Request definition:
Keywords
The
keywords correspond to values that can be specified for a Delete Request.
For more information about an individual parameter, see the Archive
User Manual .
- DEL identifier.name
- The name of the Delete Request, specified in two
parts (identifier.name), is required following
the CREATE DEL keyword.
- DESC //description//
- A description of the Delete Request, delimited by
double slashes.
General
- XF xfilname
- The fully qualified name of the Extract File used
as input for the Delete Process.
- CF cfilname
- The fully qualified name of the Control File for
the Delete Process.
- DISCARDLIMIT n
- The maximum number of rows (n)
that can be discarded.
- COMMITFREQ n
- The frequency (every nth row)
at which commits are issued.
- LOCKTBLS {Y|N}
- (Lock Tables) indicates whether
tables are locked during the Delete.
- Y
- Tables are locked.
- N
- Tables are not locked.
- INCLUDE_LOBS {Y|N}
- Indicates whether LOB columns are included in the
row comparison performed before rows are deleted.
- Y
- LOB Columns are included.
- N
- LOB Columns are not included.
Notify
This
parameter relates to the ability to send notification via email about
the outcome of the process.
- EMAILNOTIFY {A|S|F} emailaddress
- Indicates the process outcome under which to send
notification to the corresponding email address.
- A
- Always send notification.
- S
- Send notification when process succeeds.
- F
- Send notification when process fails.