MODIFY_APP_ACT_EXT_PAR

Modify specified External Application Action Parameter record.

Table: REDADM.RED_APP_ACT_EXT_PARAMS (Action parameters that will be substituted dynamically by the result set of the SQL statement in column SELECT_TEXT. Example: a parameter ‘last_mirror’ might be substituted in an email notification template with finish time stamps of mirrored databases.)

Parameter Name	Properties	Default Value	Parameter Description
p_app_name	(PK)(NN)		Name of the application as defined in table REDADM.RED_APPLICATIONS.APP_NAME
p_action_name	(PK)(NN)		Name of the action as defined in table REDADM.RED_APP_ACTIONS
p_param_name	(PK)(NN)		Action parameter name that will be substituted by the result set of the SQL statement in column SELECT_TEXT
p_select_text	(NN)		SELECT statement that returns data to substitute the parameter in column PARAM_NAME

Example

EXECUTE SCRIPT api_redadm.modify_app_act_ext_par
            ( 'XXX'      -- p_app_name
            , 'XXX'      -- p_action_name
            , 'XXX'      -- p_param_name
            , 'XXX'      -- p_select_text
            );