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
            );