ADD_LOADER_BD_COLUMN_CSV

Add new CFI-Loader(BD) Columns. For CSV-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_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

Example

EXECUTE SCRIPT api_cfiadm.add_loader_bd_column_csv
            ( 'XXXXXXXXXXXX'    -- p_ldr_name
            , 'XXXXXXXXXX'      -- p_bdomain
            , 'XXXXXXXXXXXX'    -- p_col_name
            , 'XXXXXXXXXXXX'    -- p_col_data_type
            , 9999999           -- p_col_size
            , 999               -- p_col_scale
            , 'XXXXXXXXXXXX'    -- p_col_format
            , 999999999         -- p_col_pos
            );