MODIFY_TSA_KEY_COLUMNS

Manage a TSA object - set IDC,BSK or BK columns

Parameter Name	Required	Parameter-Description
p_obj_schema	yes	TSA schema
p_obj_table	yes	TSA table
p_type	yes	type of key column (‘IDC’, ‘BSK’ or ‘BK’)
ARRAY p_key_cols	no	arary of positions (important for order, start with 1) and TSA column names (format: array (‘position,column_name’, ‘position,column_name’, …))
p_reset_flags	no	reset flags that are changed with this execution (nullable, compare,…) - true/false (if not sure, use true and execute script for ‘IDC’, ‘BSK’ and ‘BK’ consecutively)

Example

EXECUTE SCRIPT api_reppsa.modify_tsa_key_columns
           ( 'XXX'     -- p_obj_schema
           , 'XXX'     -- p_obj_table
           , 'IDC'     -- p_type
           , ARRAY ('position1,column_name1'
                   ,'position2,column_name2'
                   )   -- ARRAY p_key_cols
           , false     -- p_reset_flags
           );