Delete Requests

The following syntax is used to generate a statement for each exported Delete Request definition:

CREATE DEL identifier.name 
   [DESC //description//] 
   XF xfilname CF cfilname DISCARDLIMIT n COMMITFREQ n 
   LOCKTBLS {Y|N} INCLUDE_LOBS {Y|N}
   [EMAILNOTIFY ({A|S|F} emailaddress)];

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.