MODIFY_LOADER_COLUMNΒΆ

Change a loader column.

Parameter Name

Required

DefaultValue

Description

p_ldr_name

yes

.

(is part of PK) Name of the loader process for a specific data table as defined in DBI_LOADER.LDR_NAME (foreign key)

p_column_name

yes

.

(is part of PK) Name of the column that needs data type conversion during the load process

p_column_type

no

.

Target Exasol data type of the column to be converted

p_chunk_count

no

.

Number of columns-chunks the column to be splitted to

p_chunk_length

no

.

Length of a chunk in characters

Example

EXECUTE SCRIPT api_dbiadm.modify_loader_column
           ( 'Loader1'      -- p_ldr_name
           , 'MEIER'        -- p_column_name
           , 'varchar(200)' -- p_column_type
           , null           -- p_chunk_count
           , null           -- p_chunk_length
           );