Deleting data with Optim on distributed platforms
Use Optim™ distributed to define and manage delete processing.
The source file does not change during the delete process and can be used to reload or restore the deleted data. You can use the delete process in combination with the 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 process a delete request immediately (by clicking ) or you can schedule the request for processing at a later time (by clicking ). You must save the request before it is scheduled, but it is not necessary to save the request before it is run.
Naming conventions
The fully qualified name of a delete request consists of: identifier.name.
- identifier
- Identifier that serves as the prefix for the delete request name (1 - 8 characters).
- name
- Name assigned to the delete request (1 - 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.