The DELETE file placement policy rule statement is very similar to the RELOCATE statement in both form and function, lacking only the <TO> clause. File placement policy-based deletion may be thought of as relocation with a fixed destination.
The following XML snippet illustrates the general form of the DELETE statement:
<DELETE> <FROM> <SOURCE> <CLASS> placement_class_name </CLASS> </SOURCE> <SOURCE> additional_placement_class_specifications </SOURCE> </FROM> <WHEN> relocation_conditions </WHEN> </DELETE>
A DELETE statement contains the following clauses: