To reset counters for ALL rows or selected rows , we use the DBC.ClearAccounting macro.
The macro is defined as follows in TD 13.00:
REPLACE MACRO DBC.ClearAccounting
AS ( UPDATE Acctg SET CPU = 0, IO = 0 ALL;
UPDATE Acctg SET CPU = 0, IO = 0 ALL; );
Any reason why the same UPDATE statement is written twice in the macro?