Delete

Use the delete process to remove subsets of related data from a database. The process uses an extract or archive file to identify the set of rows to be removed. Specifications for the delete process can be stored as a delete request.

The source file is not changed during delete processing and can be used to reload or restore the deleted data. You can use the delete process in combination with an archive or extract process to safely remove data from a database. You can save the data for future restoration, as required, or load that data into another database or set of tables.

Run or Schedule

You can run a delete request immediately by clicking File > Run or you can schedule the request for processing at a later time by clicking File > Schedule. You must save a request before it is scheduled, but it is not necessary to save a request before it is run.

Naming Conventions

The fully qualified name of a delete request is in the form: identifier.name.

identifier
Identifier that serves as the prefix for the delete request name (1 to 8 characters).
name
Name assigned to the delete request (1 to 12 characters).

When you create delete requests, it is helpful to use a logical set of naming conventions to identify the use for each and to organize them for easy access.

Section Contents

This section explains how to create, maintain, and process a delete request, including how to:



Feedback