How to create import files that delete records |
To create an import file that deletes existing database records:
Step 1. On the screen on which you want to delete records, click the Define Filter 
button.
The Filter dialog box appears.
Step 2. Specify your restrictions in the Filter dialog box. When you execute the batch process to delete database records, all records that meet the specified criteria are deleted. To learn how to prepare data for individual fields, refer to the online Help for the screen.
-
Tip: You can delete any (or all) of the database records associated with the fields listed in the Filter dialog box for the screen that you are currently accessing. You can also delete records based on a wildcard, such as all equipment IDs with a specific prefix.
Step 3. Click the Get Data 
button.
The screen fields populate with the retrieved record (or records).
Step 4. To save the template and continue the batch creation process, go to how to create batch import templates.
_______________
See Also
Display a field's properties (screen, window, and control IDs; and table and column name)