Erases records from a relation. Before using the ERASE statement,
you must start a read/write transaction and establish a record
stream using a context variable with a FOR statement or a START_
STREAM statement. You cannot erase records from a view that was
formed with a WITH, REDUCED, or CROSS clause of an RDO record
selection expression. Also, you cannot erase records from a view
that was formed with a UNION clause of an SQL select expression.
Example:
RDO> START_TRANSACTION READ_WRITE RESERVING
cont> COLLEGES FOR EXCLUSIVE WRITE
RDO> FOR C IN COLLEGES
cont> ERASE C
cont> END_FOR
RDO> COMMIT
Additional Information:
explode
extract