MODIFY_PSA_DV_EXPR

Modify a DV filter expression.

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

Example

EXECUTE SCRIPT api_reppsa.modify_psa_column_expr
           ( 'XXX'     -- p_obj_schema
           , 'XXX'     -- p_obj_table
           , 'XXX'     -- p_dv_filter_expr
           , ARRAY ('position1,column_name1'
                   ,'position2,column_name2'
                   )   -- ARRAY p_dvcols
           );