Example: Using DeleteOldInDoubtV - Teradata Vantage

The following statement deletes entries logged against in-doubt transactions that were entered more than 30 days before the current calendar date:

DELETE FROM DBC.DeleteOldInDoubtV ALL;

Result:

DELETE COMPLETED. 5 ROWS REMOVED.