Loading XML data by invoking DSNUTILB

LOADPLUS invokes DSNUTILB for the following XML load jobs:

  • An SQLAPPLY load
  • A two-phase load (PRELOAD CONTINUE)
  • When loading XML data from a DBCLOB referenced file
  • When loading an XML column that is defined with an XML schema
  • When loading a table containing a user-defined XML index that is defined with DEFINE NO and is not yet materialized

Related topics

Loading-XML-data-natively

Loading-XML-data

Before you begin

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

To load XML data when LOADPLUS invokes DSNUTILB

  1. Ensure that you meet the requirements for running a load 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 XML (and any LOB) 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 XML data, either specify the XML data type in your field specification for the XML column or do not include a field specification for this job.
    • If your input file references the file that contains your XML 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*