SORTCOLS

Lists the columns that are returned from the QUERY command that are eligible to be sorted. This value must be specified after the subpanel's QUERY statement.

Note: The number of columns to be sorted can have performance implications for loading a workspace. See Workspace sort columns for considerations related to the SORTCOLS keyword.
Possible values
  • ALL (displays all columns specified in the query)
  • A comma-separated list of column names specified in the query, enclosed in single quotes. Up to 30 column names can be specified.
  • None
Default value
None

Example

SORTCOLS='CICSPLEX,PLEXRATE,PLEXCPUP'