If DELETE is specified with a WHERE clause and the specified search condition fails because it selects no rows, the value ‘02000’ is assigned to SQLSTATE, +100 is assigned to SQLCODE, and no rows are deleted.
A fastpath delete operation may not occur on load isolated tables due to presence of logically deleted rows.