MODIFY_PSA_OBJECT

Modify a PSA object.

Parameter Name	Required	Parameter-Description
p_obj_schema	yes	PSA schema
p_obj_table	yes	PSA table
p_comment	no	comment
p_delete_by_compare	no	detect deleted rows by comparing TSA FULL load with PSA - true/false
p_bsk_calc_method	no	method to recalculate BSK using PSA columns (e.g. key columns were NULL, HT columns were not resolved) - 0 = using BDOMAIN to differ calcualtion method, 1 = using TSA schema and table
p_del_method	no	delete method (close BDATE (‘B’) or TDATE (‘T’) for deleted rows)
p_deduplicate_rows	no	deduplicate rows in DV view - daily history will reduce to days with changes

Example

EXECUTE SCRIPT api_reppsa.modify_psa_object
           ( 'XXX'     -- p_obj_schema
           , 'XXX'     -- p_obj_table
           , 'XXX'     -- p_comment
           , false     -- p_delete_by_compare
           , 0         -- p_bsk_calc_method
           , 'B'       -- p_del_method
           , false     -- p_deduplicate_rows
           );