ADD_APP_ACT_EXPORTSΒΆ

Add a basic definiiton for exporting an object as part of an export action

Parameter Name

Required

Description

p_exp_name

yes

name of the file export

p_fmt_name

yes

name of the export format (see red_app_act_exp_formats)

p_obj_schema

yes

schema name of the object to be exported

p_obj_name

yes

table or view name of the object to be exported

p_filename

yes

target filename (may contain placeholders: @{bdate}, @{app_name}, @{run_id}, @{systimestamp}, @{sysdate})

p_where

yes

optional where clause (may contain placeholders like the filename)

Example

EXECUTE SCRIPT api_redadm.add_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
            );