DTRHELP.HLB  —  Commands Statements Clauses, ERASE Statement
       Permanently removes one or more data records from an indexed
       or relative data file, a Oracle CODASYL DBMS database, or a
       relational database.

       Format

         ERASE  [ALL  [OF rse] ]

1  –  Arguments

    ALL

       Causes DEC DATATRIEVE to permanently remove from the data file
       every record in the current collection.

    ALL OF rse

       Causes DEC DATATRIEVE to permanently remove from the data file
       every record identified by the record selection expression.

2  –  Examples

       The following example shows how to erase all the yachts built by
       Albin:

       DTR> FIND YACHTS WITH BUILDER EQ "ALBIN"
       [3 records found]
       DTR> ERASE ALL

       In the following example, a procedure is defined that erases
       selected yachts:

       DTR> DEFINE PROCEDURE SELL_BOAT
       DFN>     FIND YACHTS WITH BUILDER EQ *.BUILDER AND
       DFN>          MODEL = *.MODEL
       DFN>     PRINT ALL
       DFN>     IF *."Y IF BOAT SOLD" CONT "Y" THEN ERASE ALL
       DFN> END_PROCEDURE
       DTR>
Close Help