DELETE – Automatic delete processing
Sets the default value for the DELETE
keyword
of the LIST
statement.
Y
- Yes,
DELETE
theLIST
ed records. N
- No, do not
DELETE
theLIST
ed records (default). D
- Defer, generate
DELETE
statements for eachLIST
ed record and output them to theDELFILE
output destination for later processing.
Note: When
OPTIONS DELETE(Y)
is used together
with OPTIONS SELECT(Y)
, the automatically
generated SELECT
statements are processed
before the DELETE
statements, allowing Batch
Loader to be generated and saved for back out processes.