DELETE Statement

You can also remove records from a file using the DELETE statement. If a WHERE clause is included in the statement, only the selected records are removed. If no WHERE clause is included, all records in the file are removed:

DELETE FROM INVWORK

DELETE FROM INVWORK WHERE LOCATION = 'R1-001'

DELETE FROM INWORK WHERE LOCATION = 'R1-001' AND
  PART = "PART2"