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 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

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 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).

Related topics

Loading-XML-data-natively

Loading-XML-data

 

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