DELETE statement examples

The following example illustrates the use of the DELETE statement:

 <DELETE>
   <FROM>
     <SOURCE>
       <CLASS>tier3</CLASS>
     </SOURCE>
   </FROM>
 </DELETE>
 <DELETE>
   <FROM>
     <SOURCE>
       <CLASS>tier2</CLASS>
     </SOURCE>
   </FROM>
   <WHEN>
     <ACCAGE Units="days">
       <MIN Flags="gt">120</MIN>
     </ACCAGE>
   </WHEN>
 </DELETE>

The first DELETE statement unconditionally deletes files designated by the rule's SELECT statement that reside on tier3 volumes when the fsppadm enforce command is issued. The absence of a <WHEN> clause in the DELETE statement indicates that deletion of designated files is unconditional.

The second DELETE statement deletes files to which the rule applies that reside on tier2 volumes when the fsppadm enforce command is issued and that have not been accessed for the past 120 days.