Previous Topic: Using Sorting and Filtering

Next Topic: Selection List Filtering


Selection List Sorting

The columnar data can be sorted 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 Sysout Selection List and Report Selection List panels:

Field

Alias

Sequence

Description

ID

SYSOUT, SYS, S, REPORT, RID, R

Ascending

Sysout identifier and report identifier

Date

ARCH

Descending

Archive date

Loc

 

Ascending

Report location

Lines

 

Ascending

Report lines

Pages

 

Ascending

Report pages

Desc

 

Ascending

Report description

Jobname

JOB

Ascending

Job name

Jobid

ID

Ascending

Job number

Gen

 

Ascending

Generation number

Xcode

X

Ascending

Exceptional conditions

Comments

COM

Ascending

User comments

Org

 

Ascending

Origin of report

Class

 

Ascending

Sysout class

Dest

 

Ascending

Destination

Forms

FORM

Ascending

Forms name

Tapeseq

TSEQ

Ascending

Tape sequence number

Prtdate

PRT

Descending

Last printed date and time

Rdrdate

RDR

Descending

Reader date and time

Accdate

ACCESS

Descending

Last access date

Start

STRDATE

Descending

Start date

End

ENDDATE

Descending

End date

SYSTEM

SYSID

Ascending

System ID

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 stored 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.