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.

Loading LOB data by invoking DSNUTILB

LOADPLUS invokes DSNUTILB for the following types of LOB load jobs:

  • An SQLAPPLY load
  • A two-phase load (PRELOAD CONTINUE)
  • When loading a partition-by-growth table space
  • When loading from a referenced file of a different type than the column type (for example, from a BLOB referenced file to a CLOB column)

For considerations when invoking DSNUTILB, see Load-jobs-that-invoke-DSNUTILB

Before you begin

For considerations that apply when LOADPLUS invokes DSNUTILB, see Load-jobs-that-invoke-DSNUTILB.

To load LOB data when LOADPLUS invokes DSNUTILB

  1. Ensure that you meet the requirements for running a load job that invokes DSNUTILB.See Enabling-LOADPLUS-to-invoke-DSNUTILB.
  2. Include LOADLOBDATA YES on your LOAD command.
  3. If you are loading from an input data set that is in spanned-record format:
    1. Ensure that the LOB (and any XML) fields follow all other fields in your field specification.
    2. Specify FORMAT SPANNED YES.For more information about this option, including restrictions, see SPANNED
  4. Use one of the following options for your field specification:
    • If your input file contains the LOB data, either do not include a field specification for this job, or specify a LOB data type (BLOB, CLOB, or DBCLOB) in your field specification for the LOB column.
    • If your input file references the file that contains your LOB data, specify the appropriate CHAR or VARCHAR subtype (BLOBF, CLOBF, or DBCLOBF).

Related topics

Loading-LOB-data-natively

Loading-LOB-data

 

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