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*