Example 1

    Delete a single field definition:

    RDO> INVOKE DATABASE PATHNAME 'PERSONNEL'
    RDO> START_TRANSACTION READ_WRITE
    RDO> DELETE FIELD TEMP_NUM.
    RDO> COMMIT

    This sequence deletes the field definition from the physical
    database and the data dictionary.

    Example 2

    Delete more than one field definition:

    RDO> INVOKE DATABASE PATHNAME 'PERSONNEL'
    RDO> START_TRANSACTION READ_WRITE
    RDO> DELETE FIELD TEMP_NUM, MONEY.
    RDO> COMMIT

    This sequence deletes the definitions for the TEMP_NUM and MONEY
    fields from the physical database and the data dictionary.

    Example 3

    Delete a field from a relation:

    RDO> INVOKE DATABASE PATHNAME 'PERSONNEL'
    RDO> START_TRANSACTION READ_WRITE
    RDO> DELETE FIELD STATUS_NAME.
    %RDO-W-NOCDDUPDAT, database invoked by filename, the data dictionary will not be updated
    %RDB-E-NO_META_UPDATE, metadata update failed
    %RDMS-F-RELEXI, field STATUS_NAME is used in relation, WORK_STATUS
    -RDMS-F-FLDNOTDEL, field STATUS_NAME has not been deleted
    RDO> CHANGE RELATION WORK_STATUS.
    cont>  DELETE STATUS_NAME.
    cont>  END.
    RDO> DELETE FIELD STATUS_NAME.
    RDO> COMMIT

    If a field is used in a relation, you need to perform two
    operations to delete it:

    o  Change the relation by deleting the field.

    o  Delete the global field definition.