Unloading LOB and XML data to 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	DIRECT YES SPANNED YES
   Standard unload data sets	DIRECT NO

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:
   • General-considerations-when-unloading-LOB-and-XML-data
   • Considerations-when-unloading-LOB-or-XML-data-to-unload-data-sets