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.

VARCHAR


VARCHAR defines a varying-length character string.

MIXED

MIXED defines a mixed character data field. You can specify MIXED as either a subtype itself or with the CLOBF subtype.

BLOBF

BLOBF indicates that the field contains the name of a binary large object (BLOB) file that you are loading into a LOB or XML column.

When loading CLOB or DBCLOB data from a BLOB file, LOADPLUS invokes DSNUTILB.

Option

Description

PRESERVE WHITESPACE

PRESERVE WHITESPACE preserves the white space in the BLOB file when loading into an XML column.

BINARYXML

BINARYXML indicates that the referenced file contains binary XML data.

If you also specify the AVGSIZE keyword, you must specify it after BINARYXML.

AVGSIZE

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

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

DBCLOBF

DBCLOBF indicates that the field contains the name of a double-byte character large object (DBCLOB) file that you are loading into a LOB or XML column.

When loading XML, CLOB, or BLOB data from a DBCLOB file, LOADPLUS invokes DSNUTILB.

Option

Description

PRESERVE WHITESPACE

PRESERVE WHITESPACE preserves the white space in the DBCLOB file when loading into an XML column.

AVGSIZE

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

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

This option is not valid for XML input.

CLOBF

CLOBF indicates that the field contains the name of a character large object (CLOB) file that you are loading into a LOB or XML column.

When loading DBCLOB or BLOB data from a CLOB file, LOADPLUS invokes DSNUTILB.

Option

Description

PRESERVE WHITESPACE

PRESERVE WHITESPACE tells LOADPLUS to preserve the white space in the CLOB file when loading into an XML column.

AVGSIZE

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

Alternatively, for LOB input, you can specify a global value with the LOBAVGPCT command or installation option. For XML input, you can specify a global value with the XMLAVGSIZE command or installation option. The AVGSIZE field specification overrides the LOBAVGPCT and XMLAVGSIZE options.

TRIM

TRIM truncates trailing blanks from the input string value before LOADPLUS attempts to assign the value to a CHAR or VARCHAR column. If the string is still too long, a conversion error occurs. LOADPLUS performs TRIM before TRUNCATE.

Additional considerations

The following considerations apply to the TRIM option for a VARCHAR field:

  • For a DSNUTILB load, LOADPLUS translates this option to STRIP TRAILING ' ' before passing the field specification to DSNUTILB.
  • TRIM is useful when converting from a VARCHAR field to a CHAR( n) or VARCHAR( n) column and you want to detect nonblank data beyond position n.
  • If you are loading Unicode data and do not need to preserve trailing blanks, BMC strongly recommends that you specify TRIM. If translation causes an expansion of the data, specifying this option will prevent LOADPLUS from discarding records that you do not want to discard.

Restriction

This keyword is not valid with BLOBF, DBCLOBF, or CLOBF subtypes.

TRUNCATE

TRUNCATE truncates a string if it is longer than the column’s maximum length (after trimming). LOADPLUS performs TRUNCATE after TRIM.

When loading Unicode data, LOADPLUS performs truncation after translation.

Restriction

This keyword is not valid with BLOBF, DBCLOBF, or CLOBF subtypes.

Related topic

 

 

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