AutoCollect – Creating SNAPSHOT and System DELTA Rowsets › Process Snapshot Rowsets into Delta Rowsets › Deleting Delta Rowsets

Deleting Delta Rowsets

In some cases, you may want to delete DELTA rowsets that have been created. For example, you no longer need data from two years ago, or you have created a SUMMARY rowset but picked the wrong input rowsets. To clear out old data or remove incorrect rowsets before recreating the correct rowsets, you can use the DELTADEL function.

DELTADEL provides various selection parameters to limit which rowsets are deleted. Before running DELTADEL, you should run a DELTARPT using the same selection criteria to verify that only the unneeded rowsets are deleted. As a precaution, you may also decide to back up the Delta database (1020) before running the delete.

The expected return code is 0 when executing the DELTADEL function. For details about the AUTOCOLL OPTION=DELTADEL syntax, parameters, and sample output report see the CA Datacom/DB DBUTLTY Reference Guide.