MODIFY_TSA_BDATE_EXPR

Modify a BDATE expression

Parameter Name	Required	Parameter-Description
p_obj_schema	yes	TSA schema
p_obj_table	yes	TSA table
p_bdate_expr	no	bdate expression - use @# as placeholder (e.g. to_date(@1)) (NULL value indicates no changes, ‘ ‘ to clear value)
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_expr      (C) NN / maxLength=4000
                  , ARRAY ('position1,column_name1'   -- ARRAY p_act_cols
                          ,'position2,column_name2'
                          , ...
                          )
                  )