MODIFY_TSA_COL_EXPR

Modify a TSA column expression.

it is any SQL like expression, with exact one (!) placeholder, whch is set in the array parameter, the expression will be calculated during the load with the DV view so the original value of the column will be a “new” one after loading to PSA, you will not have the original value in the PSA

Parameter Name	Required	Parameter-Description
p_obj_schema	yes	TSA schema
p_obj_table	yes	TSA table
p_col_expr	no	column expression - use @# as placeholder (e.g. trim(@1)) (NULL value indicates no changes, ‘ ‘ to clear value)
p_col_datatype	no	datatype of transformed column
p_use_in_data	no	use expression in data column - true/false
p_use_in_bsk	no	use expression in BSK calculaction - true/false
p_use_in_idc	no	use expression in IDC calculaction - true/false
ARRAY p_cols	no	array of columns used in column expression (empty ARRAY indicates no changes, format: array (‘position,column_name’, ‘position,column_name’, …)

Example

EXECUTE SCRIPT api_reppsa.modify_tsa_col_expr
           ( 'XXX'     -- p_obj_schema
           , 'XXX'     -- p_obj_table
           , 'XXX'     -- p_col_expr
           , 'XXX'     -- p_col_datatype
           , false     -- p_use_in_data
           , false     -- p_use_in_bsk
           , false     -- p_use_in_idc
           , ARRAY ('position1,column_name1'
                   ,'position2,column_name2'
                   )   -- ARRAY p_act_cols
           );