Deleting rows

In a File Manager/Db2 editor session, you can delete rows by using:
  • The DELETE primary command
  • The D, Dn, or DD prefix commands in the prefix area next to each row (TABL display only)
In TABL display format, you can restrict the rows you delete by:
  • Limiting the rows that are deleted to only excluded or only non-excluded rows
  • Limiting the rows that are deleted to those within a range of rows identified by a pair of labels
  • Using the D, Dn, or DD prefix commands
In SNGL display format, DELETE deletes the currently displayed row only. To delete the currently displayed row, enter:
DELETE
Note:
  1. In TABL display format, care should be taken when using the DELETE primary command to ensure that you only delete the rows you intend to. The command DELETE ALL (with no other parameters) deletes all rows in the table or view being edited.
  2. If the table target has referential constraints, you might not be able to delete rows. For further information, see Handling errors during an Edit session.

Related tasks

Related references