MODIFY_LOADER_BD_COLUMN¶

Modify specified CFI-Loader(BD)-Columns record.

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

Parameter Name	Properties	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.modify_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
            );