UNLD ORDER BY

Use the ORDER BY option to tell BMC AMI Unload how to order the unloaded rows.


Related topics

Option descriptions—UNLD syntax
UNLD-syntax-diagrams 

ORDER_BY_syntax.png

Use one of the following specifications to indicate the order for the unloaded rows.

columnName or columnNumber

This specification tells BMC AMI Unload to order data based on the indicated columns before unloading the table. Specify one of the following keywords with the column name or number:

  • ASC tells BMC AMI Unload to sort the data in ascending order.
  • DESC tells BMC AMI Unload to sort the data in descending order.
  • RANDOM tells BMC AMI Unload to put the data in random order.

You do not need to include these columns in your select list.

Instead of specifying column names, you can specify column numbers based on their position in the select list.

SQLExpression

Use a valid SQL expression to tell BMC AMI Unload to select for unload only the rows that satisfy the criteria described in the expression. You cannot include a constant in this expression. Specify one of the following keywords with the expression:

  • ASC tells BMC AMI Unload to sort in ascending order the data that satisfies the expression.
  • DESC tells BMC AMI Unload to sort in descending order the data that satisfies the expression.
  • RANDOM tells BMC AMI Unload to put in random order the data that satisfies the expression.

CLUSTER

This keyword tells BMC AMI Unload to unload the rows in clustering index order. In the absence of a clustering index, BMC AMI Unload ignores this option. 

 

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