REMOVE_TSA_LOAD_CYCLEΒΆ

Remove specified TSA Load Cycle record(s).

Table: REDADM.RED_TSA_LOAD_CYCLES (Load cycle definition for TSA tables)

Parameter Name

Properties

Parameter Description

p_tsa_schema

(PK)(NN)

Schema name of the table in column TSA_SCHEMA in the TSA layer

p_tsa_table

(PK)(NN)

Table name in the TSA layer

p_load_cycle_cal_name

(PK)

Name of the calendar as defined in column REDADM.RED_CALENDAR_DEFINITIONS.CAL_NAME

p_load_cycle_cal_key

(PK)

Calendar key as defined in column REDADM.RED_CALENDAR_KEYS.CAL_KEY for this calendar

p_load_cycle_from

(PK)

Begin of calendar validity period. Checked against BDATE.

Example

EXECUTE SCRIPT api_redadm.remove_tsa_load_cycle
            ( 'XXX'             -- p_tsa_schema
            , 'XXX'             -- p_tsa_table
            , NULL              -- p_load_cycle_cal_name
            , NULL              -- p_load_cycle_cal_key
            , NULL              -- p_load_cycle_from
            );