ORDER
Specify the ORDER option to tell BMC AMI Unload whether to sort the output records.
The encoding scheme of the table determines the collating sequence for character data. For example, if the encoding scheme of the table is EBCDIC, the collating sequence is EBCDIC.
The ORDER and ORDER BY options are mutually exclusive. Use the ORDER BY option to order by anything other than the data-sorting key.
NO
ORDER NO is the default. ORDER NO unloads the output records in the same order in which BMC AMI Unload found the data rows in the table space.
YES
This option is meaningful only when DIRECT YES is in effect.
ORDER YES sorts the selected rows in clustering key order or, if there is no clustering key, in partitioning key order. If a selected table does not have a clustering or partitioning key, BMC AMI Unload changes this option to ORDER NO. If you are unloading a multi-table table space, BMC AMI Unload sorts first by table, then by data-sorting key.
When multiple tasks unload rows to a single output data set, all tasks execute concurrently to perform the sorting. However, BMC AMI Unload writes the selected rows in task sequence so that each output process completes before the next starts.
Considerations
The following considerations apply to ORDER YES:
- If you also specify SPANNED YES, BMC AMI Unload does not sort LOB data and the LOB data is unloaded after the sort is complete. (BMC AMI Unload sorts inline LOB data with the data.)
- BMC AMI Unload ignores this option if a clustering index does not exist on the table space.
- When DIRECT NO is in effect, BMC AMI Unload ignores ORDER YES and does not sort on the data-sorting key.
- BMC AMI Unload does not support this option when you use UNLOAD-TABLESPACE.