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