MODIFY_TSA_REFERENTIAL_PSA

Manage a TSA object - set/remove references.

Modify/add to an existing TSA object a referenced PSA object using the IDC definition as a join condition For the referenced PSA object there will be a HT table created with the IDC and optionally the BK columns.

Parameter Name	Required	Parameter-Description
p_tsa_obj_schema	yes	(PUID) TSA schema
p_tsa_obj_table	yes	(PUID) TSA table
p_tsa_column_name	yes	(PUID) TSA column name
p_ref_psa_obj_schema	no	reference PSA schema (’ ‘ to clear value, ‘-999’ for unkown reference - schema and table must be set)
p_ref_psa_obj_table	no	reference PSA table (’ ‘ to clear value, ‘-999’ for unkown reference - schema and table must be set)
p_alias_for_bk	no	alias prefix for BK join columns
p_use_in_bsk	no	use reference for BSK column - true/false
p_use_in_idc	no	use reference for IDC column - true/false

Example

EXECUTE SCRIPT api_reppsa.modify_tsa_referential_psa
           ( 'XXX'    -- p_obj_schema
           , 'XXX'    -- p_obj_table
           , 'XXX'    -- p_tsa_column_name
           , 'XXX'    -- p_ref_psa_obj_schema
           , 'XXX'    -- p_ref_psa_obj_table
           , 'XXX'    -- p_alias_for_bk
           , false    -- p_use_in_bsk
           , false    -- p_use_in_idc
           );