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 in the Delete Request
Editor.
- 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 file used as input
for the process.
- CF cfilname
- The fully qualified name of the control file for
the 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 process.
- 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 email notification 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.