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

Related topics

Loading-LOB-data-natively

Loading-LOB-data

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. If you are loading from an input data set that is in the 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
  3. 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).

 

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