Record Storage and Deletion › Record Deletion

Record Deletion

Operations Performed

To erase a record (or delete a row), CA IDMS/DB performs the following operations:

• Disconnects and/or erases all records owned by the object record, depending on the nature of the ERASE DML command issued by the program (that is, ERASE, ERASE ALL, ERASE PERMANENT, or ERASE SELECTIVE).

  Note: When using SQL, the row must not be referenced by any other row.

• Disconnects the object record from all indexed sets in which it participates as a member.
• Disconnects the object record from all chained sets (with prior pointers) in which it participates as a member.
• Deletes the record either physically or logically, as follows:
  • If all chained sets in which the record participates as a member have prior pointers, CA IDMS/DB physically deletes the record.
  • If any of the chained sets in which the record participates as a member do not have prior pointers, CA IDMS/DB logically deletes the record.

    Note: If CA IDMS/DB has identified the prior record in each chained set (without prior pointers) in which the record participates (for example, walking the set), CA IDMS/DB physically deletes the record.

    Note: All linked clustered constraints have prior pointers.