MODIFY_APP_ACT_EXPORTSΒΆ
Modify a basic export definiiton for an application action
Parameter Name Required Description =========================== =========== ============================================================================================================================= p_exp_name yes name of the file export p_fmt_name no name of the export format (see red_app_act_exp_formats) p_obj_schema no schema name of the object to be exported p_obj_name no table or view name of the object to be exported p_filename no target filename (may contain placeholders: @{bdate}, @{app_name}, @{run_id}, @{systimestamp}, @{sysdate}) p_where no optional where clause (may contain placeholders like the filename) =========================== =========== =============================================================================================================================
Example
EXECUTE SCRIPT api_redadm.modify_app_act_exports
( 'XXX' -- p_exp_name
, 'XXX' -- p_fmt_name
, 'XXX' -- p_obj_schema
, 'XXX' -- p_obj_name
, 'XXX' -- p_filename
, 'XXX' -- p_where
);