MODIFY_TSA_GROUP_COLUMNS

Modify a grouping column

Parameter Name	Required	Parameter-Description
p_obj_schema	yes	TSA schema
p_obj_table	yes	TSA table
p_view_group_column_name	no	column for grouping multiple columns together and showing them as this specified column
p_column_grp	no	value for grouping multiple columns together (NULL value indicates no changes, ‘ ‘ to clear value)
ARRAY p_grp_cols	no	array of columns that should define the group (format: array (‘position,column_name’, ‘position,column_name’, …))

Example

EXECUTE SCRIPT api_reppsa.modify_tsa_group_columns
           ( 'XXX'     -- p_obj_schema
           , 'XXX'     -- p_obj_table
           , 'XXX'     -- p_view_group_column_name
           , 99        -- p_column_grp
           , ARRAY ('position1,column_name1'
                   ,'position2,column_name2'
                   )   -- ARRAY p_grp_cols
           );