ADD_LOADER_COLUMNΒΆ

Overrule a column definition

The following data types for DB sources will be converted automatically when creating the TSA table and, therefore, need not be specified.: - PostgreSQL: uuid => varchar(26), json => text, jsonb => text - SQLServer: datetimeoffset => varchar(40), time => varchar(30), timestamp => bigint - Oracle: json => varchar(2000000), clob => varchar(2000000)

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.add_loader_column
           ( 'myLdr_Name'
           , 'myColumn_Name'
           , 'myColumn_Type'
           , null
           , null
           );

EXECUTE SCRIPT api_dbiadm.add_loader_column
          ( 'myLdr_Name'
          , 'myColumn_Name'
          , null
          , 2
          , 2000000
          );