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 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.


Feedback