DELETE – Automatic delete processing
Sets the default value for the DELETE keyword
of the LIST statement.
Y- Yes,
DELETEtheLISTed records. N- No, do not
DELETEtheLISTed records (default). D- Defer, generate
DELETEstatements for eachLISTed record and output them to theDELFILEoutput 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.