View - Mass Report Deletes

Products

• View

Issue/Introduction

There was an attempt to delete all of the CPB* reports from the View database using the ERO table. However, the reports did not get deleted. 

The ERO table was updated with: 

  /CPB* ALL DRETPD=0 RETPD=0 

 Is there a way to perform the mass deletes of all the prefixed reports in batch?

Resolution

Below are the steps to perform the mass deletes using ERO Table:

 . Add a catch-all entry to the ERO table (/* ...)
 . Set SARINIT EROPRO=ALL and PRETAIN=TABLE
 . Recycle SARSTC
 . Run a View backup

 At the backup, the desired reports were removed.