Improvements to SCV Purge Planning Table program

The SCV program PURGE_PLANNING_DATA is extended to allow purging data by date. The program now accepts these new parameters:

  • DATE_COLUMN (optional): Optional parameter. Name of the column that holds the reference date to purge older data. If specified, the column must exist in all tables in scope.
  • DAYS_TO_KEEP (optional): The number of days old data to purge. If specified, the DATE_COLUMN parameter must also be specified.

When the DATE_COLUMN and DAYS_TO_KEEP parameters are specified, the purge program determines the maximum date value available in the specified DATE_COLUMN and deletes all records that are older than the existing maximum date value minus the specified DAYS_TO_KEEP.

Note: By default, this feature is enabled. A new role or privilege is not required to access this feature.