SET_MAIL_PARAM

Modify specified DBIADM Mail Parameter record.

Table: DBIADM.ADM_MAIL_PARAMS (Email templates for the local schema)

Parameter Name	Properties	Default Value	Parameter Description
p_id	(PK)(NN)		Unique name of a notification email. Lua scripts use this ID as an identifier for sending the email.
p_subject	(NN)		Email subject
p_body	(NN)		Email body text. It may contain HTML tags and variables (e.g.: @{user_name}, @{ENV}, @{sbx_name}, …) that will be substituted by the calling LUA script.

Example

EXECUTE SCRIPT api_dbiadm.set_mail_param
            ( 'XXX'      -- p_id
            , 'XXX'      -- p_subject
            , 'XXX'      -- p_body
            );