MODIFY_TSA_BDATE_INIT_EXPR

Modify a initial BDATE expression

Parameter Name	Required	Parameter-Description
p_obj_schema	yes	TSA schema
p_obj_table	yes	TSA table
p_bdate_init_expr	yes	bdate expression used for initial load - use @# as placeholder (e.g. to_date(@1))
ARRAY p_bdatecols	no	array of columns used in bdate expression (empty ARRAY indicates no changes, format: array (‘position,column_name’, ‘position,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_init_expr (C) NN / maxLength=4000
                  , ARRAY ('position1,column_name1'   -- ARRAY p_act_cols
                          ,'position2,column_name2'
                          , ...
                          )
                  )