The CLOB format is used to load the entire content of the file into a single column in a data set.
It can be extremely useful when you just want to make a few changes in the source document without applying a full-fledged source-to-destination transformation.
To create a new CLOB format go to Connections, select Formats tab, click Add Format button and type in clob in the search field.
The following parameters are available when configuring the format:
- Column Name - the value of this property will be used as a column name when loading the content of the file into a single column in a data set. The default column name is
- Default Extension - the default extension is used when the file name doesn't have an extension. If not entered,
txtis the default extension.
- Encoding - character encoding when reading and writing a file.
No encodingmeans there will be no additional encoding.