Data Manipulation Language Statements › @ERASE—disconnects or erases records › @ERASE Example

@ERASE Example

     @ERASE PERMANENT,REC='DEPT'

     @ERASE SELECTIVE,REC='TCHR'

     @ERASE ALL,REC='TCHR'

The sample employee database affords no appropriate examples of these parameters; a sample high school database is used instead. The outcome of the @ERASE statement varies, based on the qualifier specified (PERMANENT, SELECTIVE, or ALL). Although all three qualifiers cause all mandatory members owned by the specified record to be erased, they differ in their effect on optional members.