ADD_OBJECT

Add a PSA object into the all repository including all TSA dependencies.

Table: REPPSA.*

Adding a PSA object and all dependencies into the repository, additionally to the PSA and TSA parameters, information of SCD type (2 or 3), deleteion method (‘T’ or ‘B’ - used to set data rows inactive with business date or technical date). The script can also be used to add additional TSA sources to existing PSA/TSA definitions. The metadata is created with standard configurations. Key definitions like IDC, BSK, BK, BDATE expressions or other specific configurations are set by using seperate API calls like MODIFY APIs

Parameter Name	Properties	Default Value	Parameter Description
p_psa_obj_schema	(PK)(NN)		PSA schema
p_psa_obj_table	(PK)(NN)		PSA table
p_scd_type	(NN)		SCD Type (2 or 3)
p_comment			optional comment
p_del_method	(NN)		delete method (close BDATE (‘B’) or TDATE (‘T’) for deleted rows)
ARRAY p_tsa_tables	(NN)		array of dependent TSA tables (format: array (‘TSA_SCHEMA,TSA_TABLE,BDOMAIN’,…)

Example

EXECUTE SCRIPT api_reppsa.add_object
           ( 'XXX'    -- p_join_name
           , 'XXX'    -- p_psa_obj_schema
           , 2        -- p_scd_type
           , 'XXX'    -- p_comment
           , 'B'      -- p_del_method
           , ARRAY ('TSA-Schema1TSA-Tab1,BDomain1'
                   ,'TSA-Schema1TSA-Tab1,BDomain1'
                   )  -- ARRAY p_tsa_tables
           );