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'
, ...
)
)