ADD_APP_ACT_EXP_FMT

Add new Application Action Export Format.

Table: REDADM.RED_APP_ACT_EXP_FORMATS

Parameter Name	Properties	Default Value	Parameter Description
p_fmt_name	(PK)(NN)		name of the file format
p_fmt_type	(NN)	‘csv’	format type: CSV, PARQUET
p_date_format	(NN)	‘yyyymmdd’	nls_date_format for the export session
p_timestamp_format	(NN)	‘yyymmddhh24miss’	nls_timestamp_format for the export session
p_encoding	(NN)	‘utf8’	encoding for the export session
p_header	(NN)	FALSE	include column names as firs row true/false
p_null_string			optional replacement string for NULL values
p_boolean_string	(NN)	‘true/false’	replacement string for boolean values
p_delimit	(NN)	‘always’	delimit columns: always, auto, never
p_column_separator	(NN)	‘;’	CSV only: column separator
p_row_separator	(NN)	‘LF’	CSV only: row separator: LF, CRLF
p_bdate_first_col	(NN)	FALSE	include BDATE as first column: true/false
p_numeric_characters	(NN)	‘.,’	Custom decimal and thousand separators. Must contain only 2 characters - one for each separator

Example

EXECUTE SCRIPT api_redadm.add_app_act_exp_fmt
            ( 'XXX'                  -- p_fmt_name
            , 'csv'                  -- p_fmt_type
            , 'yyyymmdd'             -- p_date_format
            , 'yyymmddhh24miss'      -- p_timestamp_format
            , 'utf8'                 -- p_encoding
            , FALSE                  -- p_header
            , 'XXX'                  -- p_null_string
            , 'true/false'           -- p_boolean_string
            , 'always'               -- p_delimit
            , ';'                    -- p_column_separator
            , 'LF'                   -- p_row_separator
            , FALSE                  -- p_bdate_first_col
            , '.,'                   -- p_numeric_characters
            );