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.

Related topic

Data type keywords

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.

 

 

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