ADD_LOADER_BD_FBV

Add new CFI-Loader(BD). For FBV-files only.

Table: CFIADM.CFI_LOADER_BD (BDomain specific CFI loader definitions)

Parameter Name	Properties	Default Value	Parameter Description
p_ldr_name	(PK)(NN)		Name of the loader process for a specific file as defined in CFI_LOADER.LDR_NAME (foreign key)
p_bdomain	(PK)(NN)		Name of the business domain as defined in CFI_BDOMAIN_SETTINGS.BDOMAIN (foreign key)
p_file_name_pattern	(NN)		Regular expression that matches one or more file names to be loaded
p_bdate_pattern			If the file name contains the BDATE: regular expression that matches the BDATE-part of the file name.
p_bdate_fmt			If the file name contains the BDATE: format of the BDATE contained in the file name for conversion to timestamp.
p_tsa_schema	(NN)		Target schema name in the TSA layer.
p_tsa_table	(NN)		Target table name in the TSA layer.
p_active	(NN)		Turn loader on/off. Possible values: true or false.
p_bdate_epoch			BDATE for initial load in case of master data without date information
p_status_finished_offset	(NN)	0	Offset in minutes from the date, when the status of the TSA table will change to ‘FINISHED’. Default value: 0
p_file_encoding	(NN)	‘UTF-8’	Character encoding of the file. Default value: UTF-8.
p_file_row_separator	(NN)	‘LF’	New line separator. Values: LF, CR, CRLF, NONE. ‘NONE’ is only allowed for FBV files
p_file_skip_rows	(NN)	0	Number of rows to be skipped at the beginning of the file (e.g. header rows). Default value: 0.
p_file_fbv_row_size			Optional row size for FBV files. The row size is needed to recognize the end of a row if the last column is empty.
p_file_reject_limit	(NN)	0	Allowed number of rows with errors before the import is terminated. Default value: 0. For FBV files the reject limit is always 0.
p_part_number_pattern			Regular expression to identify a part number within the file name. Only useful if data is split into several files with sequential file names
p_bdate_ffdl_prev_day	(NN)	TRUE	In case of a first FULL daily load (i.e. the first one after midnight) use the previous day for BDATE. Possible values: true or false
p_numeric_characters			Custom decimal and thousand separators. Must contain only 2 characters - one for each separator.

Example

EXECUTE SCRIPT api_cfiadm.add_loader_bd_fbv
            ( 'XXXXXXXXXXXX'    -- p_ldr_name
            , 'XXXXXXXXXX'      -- p_bdomain
            , 'XXXXXXXXXXXX'    -- p_file_name_pattern
            , 'XXXXXXXXXXXX'    -- p_bdate_pattern
            , 'XXXXXXXXXXXX'    -- p_bdate_fmt
            , 'XXXXXXXXXXXX'    -- p_tsa_schema
            , 'XXXXXXXXXXXX'    -- p_tsa_table
            , FALSE             -- p_active
            , '2025-03-10'      -- p_bdate_epoch
            , 999999999999      -- p_status_finished_offset
            , 'XXXXXXXXXXXX'    -- p_file_encoding
            , 'XXXX'            -- p_file_row_separator
            , 999999999999      -- p_file_skip_rows
            , 999999999999      -- p_file_fbv_row_size
            , 999999999999      -- p_file_reject_limit
            , 'XXXXXXXXXXXX'    -- p_part_number_pattern
            , FALSE             -- p_bdate_ffdl_prev_day
            , 'XX'              -- p_numeric_characters
            );