MODIFY_PSA_MAND_CLOSE_EXPR

Modify a mandatory closing expression.

Parameter Name	Required	Parameter-Description
p_obj_schema	yes	PSA schema
p_obj_table	yes	PSA table
p_mandclos_expr	no	mandatory closing expression in PV 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 mandatory closing expression (empty ARRAY indicates no changes, format: array (‘position,column_name’, ‘position,column_name’, …)
ARRAY p_mandcols_grp	no	array of columns used in partition by clause of mandatory closing expression (empty ARRAY indicates no changes, format: array (‘position,column_name’, ‘position,column_name’, …)

Example

EXECUTE SCRIPT api_reppsa.modify_psa_mand_close_expr
           ( 'XXX'     -- p_obj_schema
           , 'XXX'     -- p_obj_table
           , 'XXX'     -- p_mandclos_expr
           , ARRAY ('position1,column_name1'
                   ,'position2,column_name2'
                   )   -- ARRAY p_dvcols
           , ARRAY ('position1,column_name1'
                   ,'position2,column_name2'
                   )   -- ARRAY p_mandcols_grp
           );