LISTX Sorting

Start of changeThe record list order of the Performance List Extended report can be modified with the ASCEND or DESCEND suboperand of the FIELDS operand. You can sort by multiple fields. The order in which the FIELDS operands appear in the LISTX command determines the sort precedence: the first FIELDS operand that specifies a sort sequence in the LISTX command is the major sort field, and each subsequent FIELDS operand with a sort sequence is one level lower in precedence. Start of change
CICSPA LISTX(FIELDS(field1(ASCEND|DESCEND),...))
End of change End of change

The sort fields that can be specified for the Performance List Extended report are Application Groups, user fields, or the CMF fields listed in Fields by forms, HDB templates column and the fields marked S.

Start of changeIf no sort fields are specified, the following rules apply:
  1. If any character field is present, the first character field is used as an ascending sort key.
  2. Otherwise, an error message is displayed.
End of change