DELETE statement examples

Article:HOWTO59532  |  Created: 2011-10-12  |  Updated: 2011-10-12  |  Article URL http://www.symantec.com/docs/HOWTO59532
Article Type
How To

Product(s)

Environment

Subject


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.

See DELETE statement


Legacy ID



uxrt-51sp1_v40222378_v63475671


Article URL http://www.symantec.com/docs/HOWTO59532


Terms of use for this information are found in Legal Notices