Deleting Multiple Rows
Go Up to Deleting Data (Embedded SQL Guide)
There are two methods for modifying rows:
- The searched delete method, where the same deletion condition applies to a number of rows, is most useful for automated removal of rows.
- The positioned delete method, where rows are retrieved through a cursor and deleted row by row, is most useful for enabling users to choose which rows that meet certain conditions should be removed.
A searched delete is easier to program than a positioned delete, but less flexible.