ADD_PSA_OBJECT

Add a PSA object.

Parameter Name

Required

DefaultValue

Parameter-Description

p_obj_schema

yes

PSA schema

p_obj_table

yes

PSA table

p_scd_type

yes

SCD Type (2 or 3)

p_comment

no

optional comment

p_del_method

yes

delete method (close BDATE (‘B’) or TDATE (‘T’) for deleted rows)

Example

EXECUTE SCRIPT api_reppsa.add_psa_object
           ( 'XXX'     -- p_obj_schema
           , 'XXX'     -- p_obj_table
           , 2         -- p_scd_type
           , 'XXX'     -- p_comment
           , 'B'       -- p_del_method
           );