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
);