DBCLOB
DBCLOB indicates a field that contains double-byte character large object (DBCLOB) 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.
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*