SPANNED YES

The SPANNED YES option enables you to unload the LOB auxiliary table and the base table in a single unload job. BMC AMI Unload unloads the data to a variable-block spanned (VBS) data set.

The following considerations apply to this option:

  • You do not need an BMC AMI Reorg AUX YES license to use this feature.
  • If you do not specify SPANNED YES, BMC AMI Unload unloads only the base table—even if your unload selection includes a LOB column.
  • If you also specify the BMC-AMI-Unload-OUTPUT-command for your output data set, SPANNED YES takes precedence over the OUTPUT command.

Related topics

Option descriptions—UNLD syntax
UNLD-syntax-diagrams
SPANNED YES (UNLOAD syntax) 

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

Do not use MODE(DB2SQL) or MODE(AUTO) with this option.



 

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