MODIFY_LOADER_BD_COLUMN_FBV

Modify specified CFI-Loader(BD) Columns record. For FBV-files only.

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_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_fbv
            ( 'XXXXXXXXXXXX'    -- p_ldr_name
            , 'XXXXXXXXXX'      -- p_bdomain
            , 'XXXXXXXXXXXX'    -- p_col_name
            , 'XXXXXXXXXXXX'    -- p_col_data_type
            , 999999999         -- p_col_pos
            , 999999999         -- p_col_fbv_size
            , 999999999         -- p_col_fbv_start
            , 'XXXXX'           -- p_col_fbv_align
            , 'XXXXXXXXXX'      -- p_col_fbv_padding
            );