MODIFY_TSA_FUSION_COLUMNS¶
Modify a fusion definition.
Parameter Name |
Required |
Parameter-Description |
---|---|---|
p_obj_schema |
yes |
TSA schema |
p_obj_table |
yes |
TSA table |
p_fusion_method |
no |
fusion method as defined in REP_TSA_FUSION_DEFINITION (NULL value indicates no changes, ‘ ‘ to clear value) |
p_fusion_grp |
no |
grouping value for connected fusion columns |
ARRAY p_fusion_col |
no |
array of fusion columns (empty ARRAY value indicates no changes, format: array (‘position,column_name’, ‘position,column_name’, …)) |
Example
EXECUTE SCRIPT api_reppsa.modify_tsa_fusion_columns
( 'XXX' -- p_obj_schema
, 'XXX' -- p_obj_table
, 'XXX' -- p_fusion_method
, 99 -- p_fusion_grp
, ARRAY ('position1,column_name1'
,'position2,column_name2'
) -- ARRAY p_fusion_col
);