DELETE statement examples

Description

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

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)