SPANNED

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

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 (for BMC AMI Unload).

• 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.