When adding or changing retentions for some reports in a View database, the SARINIT parameters EROPRO and PRETAIN are of good use.
Upon making a change to the ERO table, ensure that EROPRO is set to either EROPRO=YES (the recommended setting) or EROPRO=ALL (a one-time setting).
ERO retentions are re-evaluated automatically with EROPRO=YES, and the setting of EROPRO=ALL gets reset to the default of EROPRO=NEW, at the next View backup.
With PRETAIN=TABLE, the ERO table is used as the only point of reference for retention.
With PRETAIN=INIT, the SARINIT NGEND and NGENT are also taken into consideration, where the longer amount of time is considered.