Selecting and Retrieving Reports › Using Sorting and Filtering › Selection List Sorting

Selection List Sorting

You can sort the column data in a predefined sort sequence. Generally, all fields sort in ascending sequence except date fields. The following table indicates the sort field name and sequence for the Selection List panels:

Note: The 'Lines' column on the Sysout Selection panel displays either the number of lines associated with a mainframe sysout group, or the number of bytes associated with a PC File in the database.

The mainframe sysout groups always display the value that represents the number of lines in whole integers. The smallest number that appears in this column is 1.

The PC files are displayed in K (Kilobyte), M (Megabyte) or, G (Gigabyte) notation. The sorting is performed on the integer value stored in this field, not on the K, M, or G.

Note: The smallest number that appears in this column is 1K, even if the file is one byte.

For example, a PC file of 200 bytes might appear to be sorted between the two mainframe sysout groups, 100 lines and 300 lines and is displayed as:

 ------------- Sysout Selection List -------------------------------
Command ===>                                                  Scroll ===> HALF 

me    Jobid      Arch Date     Time     Loc      Lines    Pages    Xcode 
      *          *             *        *        *        *        * 
nnn   nnnnnnnn   mm/dd/yyyy    hh:mm    llll     100      1
nnn   nnnnnnnn   mm/dd/yyyy    hh:mm    llll     1K       0
nnn   nnnnnnnn   mm/dd/yyyy    hh:mm    llll     300      1

The sort is performed on an integer value in this field and the items are sorted in K, M, or G notation order. The files can appear to be sorted out of sequence.