MODIFY_ERASE_GROUPΒΆ

Modify specified Erase Group record.

Table: REDADM.RED_ERASE_GROUPS (All Erase Groups)

Parameter Name

Properties

Default Value

Parameter Description

p_erase_group

(PK)(NN)(UC)

Name of the erase group

p_description

(NN)

Description of the erase group

p_std_retention

(NN)

99999

The standard period, in days, for which data should be retained - bdate columns are used for this test

p_tdate_closed_retention

(NN)

99999

The period, in days, for which technically closed data should be retained - tdate columns are used for this test

p_spec_cal_name

Name of the calendar used to define the special dates for which data should be retained

p_spec_cal_key

Name of the calendar key used to define the special dates for which data should be retained

p_spec_retention

The period, in days, for which data defined by the special calendar should be retained

p_active

(NN)

TRUE

Example

EXECUTE SCRIPT api_redadm.modify_erase_group
            ( 'XXX'      -- p_erase_group
            , 'XXX'      -- p_description
            , 99999      -- p_std_retention
            , 99999      -- p_tdate_closed_retention
            , 'XXX'      -- p_spec_cal_name
            , 'XXX'      -- p_spec_cal_key
            , 0          -- p_spec_retention
            , FALSE      -- p_active
            );