CLOB
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*