SPANNED

The SPANNED option tells BMC AMI Unload whether you want to unload your LOB data to a data set in spanned-record format.

GUID-25C531CA-324A-42A4-A261-16ADCB6D6CA8-low.png

Related topics

BMC AMI Unload option descriptions

UNLOAD-syntax-diagrams 

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

NO

NO, the default, tells BMC AMI Unload not to unload LOB data to a data set in spanned-record format.

YES

YES tells BMC AMI Unload to unload LOB data to a data set in spanned-record format.

The following general considerations apply when you unload to spanned-record data sets with SPANNED YES:

  • BMC AMI Unload terminates if you use SYSOUT=* as your SYSREC DD. 
  • BMC AMI Unload overrides any record format or record size that you specify in your JCL for output data sets.
  • The LOB columns must be listed at the end of the field specification.

The following considerations apply to the options that you specify when you unload to spanned-record data sets with SPANNED YES:

  • BMC AMI Unload ignores any translation specification and unloads the data using the encoding scheme of the current table. The LOAD statement that BMC AMI Unload generates includes the CCSID option with the current encoding scheme. For more information, see CCSID.
  • If you specify NULLTYPE with an L value, BMC AMI Unload changes it to the comparable T value. 
  • When you specify SPANNED YES, BMC AMI Unload ignores FIXEDVARCHAR YES. 



 

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