The following statement deletes entries logged more than 30 days before the current calendar date:
DELETE FROM DBC.DeleteAccessLogV ALL;
Result:
DELETE COMPLETED. 79 RECORDS DELETED.
The following statement deletes entries logged more than 30 days before the current calendar date:
DELETE FROM DBC.DeleteAccessLogV ALL;
Result:
DELETE COMPLETED. 79 RECORDS DELETED.