SPANNED

The SPANNED option tells UNLOAD PLUS whether you want to unload your LOB and XML data to a standard variable-block spanned (VBS) data set. The format of this data set is similar to the IBM proprietary spanned record format.

Related topic

Basic-processing-options

SPANNED.png

This option is valid only when DIRECT YES is in effect.

Important

The FORMAT SPANNED YES option of the IBM Db2 LOAD utility requires that the input be in the IBM proprietary spanned record format. Therefore, you cannot use the IBM Db2 LOAD utility to load the VBS data set that UNLOAD PLUS produces.

NO

NO, the default, tells UNLOAD PLUS not to unload LOB and XML data to a VBS data set.

YES

YES tells UNLOAD PLUS to unload LOB and XML data to a VBS data set. For more information, see Unloading-LOB-and-XML-data.

For considerations that apply when you specify SPANNED YES, see Considerations-when-unloading-LOB-or-XML-data-to-unload-data-sets.

 

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