ADD_LOADER_BD_COLUMN

Add new CFI-Loader(BD)-Columns.

Table: CFIADM.CFI_LOADER_BD_COLUMNS (Table for column definition of files)

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_col_name	(PK)(NN)		Name of the column
p_col_data_type	(NN)		Data type of the column (e.g. VARCHAR, DECIMAL, BOOLEAN, DATE,…)
p_col_size			Number of characters (VARCHAR) or precision (DECIMAL) of a data type
p_col_scale			Scale of a numeric data type
p_col_format			Optional data format of the column in the file. E.g. a date format like DD.MM.YYYY or a numeric format like 999.9
p_col_pos	(NN)		Column ordinal position
p_col_fbv_size			Column size in FBV files
p_col_fbv_start			Optional column start position in FBV files
p_col_fbv_align			Optional column alignment in FBV files. Possible values: LEFT or RIGHT. Default value: LEFT
p_col_fbv_padding			Optional column padding character(s) in FBV files. Default value: ‘ ‘ (blank space)

Example

EXECUTE SCRIPT api_cfiadm.add_loader_bd_column
            ( 'XXX'      -- p_ldr_name
            , 'XXX'      -- p_bdomain
            , 'XXX'      -- p_col_name
            , 'XXX'      -- p_col_data_type
            , 0          -- p_col_size
            , 0          -- p_col_scale
            , 'XXX'      -- p_col_format
            , 0          -- p_col_pos
            , 0          -- p_col_fbv_size
            , 0          -- p_col_fbv_start
            , 'XXX'      -- p_col_fbv_align
            , 'XXX'      -- p_col_fbv_padding
            );