RDOHELP72.HLB  —  ERASE
    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
Format More Examples
Close Help