Technical data

The occurrence diagrams in Figure 6–7 show the results of using the ERASE ALL
statement.
Figure 6–7 Results of an ERASE ALL
SET_C
SET_B
B2
B3B1
OWNER
A1 A4
A3
SET_A
ERASE
A2
OWNER
A1 A4SET_A
AFTER ERASE ALLPRIOR TO ERASE ALL
A3
C1
C2
ZK−1515−GE
The ERASE ALL statement is the only way to erase an owner of sets with
MANDATORY members.
6.9 ERASE Record-Name
If you do not use the ERASE ALL statement but use the ERASE record-name,
and the erased record is the owner of a set, the ERASE statement deletes:
• The current record.
• All FIXED members of sets owned by the current record.
• All FIXED members of sets owned by records in rule 2. Note that this is a
repetitive process.
If the current record owns sets with OPTIONAL members, these records are
disconnected from the set, but remain in the database.
The occurrence diagrams in Figure 6–8 show the results of using the ERASE
record-name statement when affected members have an OPTIONAL set
membership. In this figure, B records are FIXED members of the SET_B
set and C records are OPTIONAL members of the SET_C set. Notice that records
C1 and C2 are disconnected from the set, but remain in the database while B1
through B3 are erased.
DML Programming—Tips and Techniques 6–11