MODIFY_TSA_ACTIVE_EXPR

Modify an ACTIVE expression

Parameter Name	Required	Parameter-Description
p_obj_schema	yes	TSA schema
p_obj_table	yes	TSA table
p_active_expr	no	active expression - use @# as placeholder (e.g. nvl(@1, @2) > 0) (NULL value indicates no changes, ‘ ‘ to clear value)
ARRAY p_act_cols	no	array of columns used in active expression (empty ARRAY indicates no changes, format: array (‘position,column_name’, ‘position,column_name’, …)

Example

EXECUTE SCRIPT api_reppsa.modify_tsa_active_expr
           ( 'XXX'     -- p_obj_schema
           , 'XXX'     -- p_obj_table
           , 'XXX'     -- p_active_expr
           , ARRAY ('position1,column_name1'
                   ,'position2,column_name2'
                   )   -- ARRAY p_act_cols
           );