Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Pool Advisor for Db2 13.1.

SORT

SORT is a basic panel command that can be issued from any product panel containing a keyed scrollable table and in reports containing repeating groups of data.

SORT is used to change the order of data displayed:

  • On keyed scrollable panels, the SORT command changes the column used as the sort key.
  • On reports containing repeating groups, the groups are rearranged using the indicated field as the sort key within the boundaries of the group level. Both a primary and secondary sort key can be specified.

SORT A (ascending) is the default value assigned to the F4 key and SORT D (descending) is the default value assigned to the F5 key.

GUID-D1F181FA-67D8-40E4-9ED3-5CDD29677862-low.png

Parameter

Description

1

Applies to reports only. Used to specify the primary sort key. 1 is the default.

2

Applies to reports only. Used to specify the secondary sort key.

ASCENDING

Data is sorted in alphabetical or numerical order with the lowest value listed first. ASCENDING is the default.

DESCENDING

Data is sorted in alphabetical or numerical order with the highest value listed first.

To issue the SORT command, perform one of the following actions:

  • Type SORT (with or without parameters) on the Command line, move the cursor to the column to be used as the sort key, and press Enter
  • Move the cursor to the column to be the new sort key, and press F4 or F5

Related topic

Commands



 

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