Loading CLOB Data

The CLOB data can be loaded in two ways:

• Extracted as part of the main data file. This method is suitable for the relatively small CLOB data size. Refer to Limitations for more details.

• Extracted into a separate file. This method is suitable for larger CLOB data sizes and also for large volume tables or maintenance objects. In this scenario, the secondary file has to be uploaded at the same time as the primary data file.

  Note: When loading CLOB data as a secondary file, a separate file is created for each CLOB field in the. It means that if the table ‘XXX’ contains CLOB fields ‘clob1Field1’ and ‘clobField2’, the system would expect to process files XXX, XXX_​clobField1_​CLOB and XXX_​clobField2_​CLOB. See also Notes on Secondary Data Files