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.
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.