MODIFY_TSA_BK_COLS_FOR_HTJOIN

Manage a TSA object - set/remove BK columns that should be included on HT join

Parameter Name

Required

Parameter-Description

p_obj_schema

yes

TSA schema

p_obj_table

yes

TSA table

ARRAY p_bk_cols

no

array of TSA columns that should be included on HT join - true/false (empty array to clear columns - format: array (‘column_name’, ‘column_name’, …))

Example

EXECUTE SCRIPT api_reppsa.modify_tsa_bdate_expr
                  ( 'XXXXXXXXXX'            -- p_obj_schema      (C) NN / maxLength=128
                  , 'XXXXXXXXXXXXXXXXXXXX'  -- p_obj_table       (C) NN / maxLength=128
                  , 'XXXXXXXXXXXXXXXXXXXX'  -- p_bdate_expr      (C) NN / maxLength=4000
                  , ARRAY ('column_name1'   -- ARRAY p_act_cols
                          ,'column_name2'
                          , ...
                          )
                  )