Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see LOADPLUS for DB2 13.1.

CLOB


CLOB indicates a field that contains character large object (CLOB) data.

A four-byte length field precedes the string. This length does not include the four length bytes.

Restriction

LOADPLUS terminates if you specify DEFAULTIF or VALUE on a LOB column.

MIXED

MIXED indicates that the CLOB input field contains mixed data.

AVGSIZE

This option provides an estimate of the actual size of the input data by specifying a number, optionally followed by the unit of measure (K, M, or G). The minimum value that you can specify is 1K. The maximum values that you can specify are 2G, 2048M, or 2097152K. The default unit of measure is K.

Alternatively, you can specify a global value with the LOBAVGPCT command or installation option. The AVGSIZE field specification overrides the LOBAVGPCT option.

Related topic

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*