Loading XML data natively

For those conditions under which LOADPLUS invokes DSNUTILB, see Loading-XML-data-by-invoking-DSNUTILB.

Before you begin

Review Considerations-for-loading-XML-data-natively.

To load XML data natively

1. Create your load job as usual, adjusting it if necessary based on the information described in Considerations-for-loading-XML-data-natively.
2. Use one of the following options for your field specification:
   • If your input file contains the XML data, either do not include a field specification for this job, or specify the XML data type in your field specification for the XML column.
   • If your input file references a BLOB or CLOB file that contains your XML data, specify the BLOBF or CLOBF subtype, respectively, on the appropriate CHAR or VARCHAR data type. Specify any applicable subtype options.
3. 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
4. If you specify COPY YES, ensure that dynamic allocation is enabled for your XML copy data sets.
5. (optional) Adjust the value for the XMLAVGSIZE option on your LOAD command or the AVGSIZE option on your field specification.For more information about these options, see XMLAVGSIZE or AVGSIZE.
6. Ensure that the SMF MEMLIMIT parameter meets the minimum requirements for loading your XML data.For more information, see Overriding-the-MEMLIMIT-system-parameter.