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