Deleting rows within excluded or non-excluded rows

If your data contains excluded and non-excluded rows, you can limit the effect of the DELETE command to:
  • Only non-excluded rows (parameter NX), or
  • Only excluded rows (parameter EX or X)
For example, the following command deletes all excluded rows:
DELETE ALL EX
And the following command deletes the first non-excluded row:
DELETE NX

Related tasks

Related references