Space announcement


This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Unloading LOB and XML data to unload data sets

You can unload LOB (including inline LOB) or XML data to the following types of unload data sets:
  • (DIRECT YES only) VBS unload data sets

  • (DIRECT NO only) standard unload data sets

To unload LOB or XML data to unload data sets

  1. Ensure that the following options are in effect, based on the type of unload data set that you intend to use:

    Type of data set

    Required option settings

    VBS unload data sets



    Standard unload data sets


  2. Use one of the following options for your field specification:
    • Include no field specification on your UNLOAD command.

    • Include a field specification for the column that you are unloading:

      • For an XML column, specify the XML data type.

      • For a LOB column, specify the BLOB, CLOB, or DBCLOB data type.

  3. Adjust your job based on following the considerations:
Was this page helpful? Yes No Submitting... Thank you