SORT

SORt  heading [ ASC | DESC ]   

heading

Name of the heading on the panel to be sorted. For example, SORT TYPE sorts the list by the values under Type. Many of the headings have abbreviations that can be used for convenience.

ASC

Sort the entries on the selection list in ascending order (A to Z, zero to 9, or earliest to latest date). Default.

DESC

Sort the entries on the selection list in descending order (Z to A, 9 to zero, or latest to earliest date).

• This command can be entered on the following selection lists:
  • Select Table or View to Browse
  • Select Table or View to Edit
  • Select ADs to Browse Tables
  • Select ADs to Edit Tables
  • Select Access Definition
  • Select Compare Definition
  • Select Primary Keys
  • Select Relationships
  • Select Column Maps
  • Select Table Maps
  • Select an Access Definition
  • Select Legacy Table
  • Choose an Environment Definition
  • Choose a Retrieval Definition
  • Select Tables/Views For AD
  • Specify Relationship Usage
  • Pending Process List
• The Select Relationships panel has non-unique headings, therefore, the following keywords can be used to sort on values under a displayed heading:

  CREator

  Sort using the child table Creator ID.

  TABle

  Sort using the child table name.

  PCReator

  Sort using the parent table Creator ID.

  PTAble

  Sort using the parent table name.

  CHIld

  Sort using the fully qualified name of the child table.

  PARent

  Sort using the fully qualified name of the parent table.

  RELation

  Sort by relationship name.

  TYPe

  Sort by the type of relationship.

  STAtus

  Sort alphabetically using the status in Status. Those tables with no status are listed first.

  SECurity

  Sort using the security status of the Relationship.

  SECurity DEScription

  Sort using the security status and description of the Column Map.

  The heading on which the sort is requested is used as the default target heading for any succeeding LOCATE command.

  The default for SORT is ascending order (ASC).

• The Select Column Maps panel has non-unique headings, therefore, the following keywords can be used to sort on values under a displayed heading:

  ID

  Sort using the Column Map Creator ID.

  NAME

  Sort using the Column Map name.

  CREator

  Sort using the destination table Creator ID.

  TABle

  Sort using the destination table name.

  SCReator

  Sort using the source table Creator ID.

  STAble

  Sort using the source table name.

  CHIld

  Sort using the fully qualified name of the child table.

  PARent

  Sort using the fully qualified name of the parent table.

  SECurity

  Sort using the security status of the Column Map.

  SECurity DEScription

  Sort using the security status and description of the Column Map.

• The following keywords can be used to sort on values under a display heading on the Select Tables/Views for AD panel:

  ACCess

  Sort using Access Rights.

  DAA

  Sort using delete after archive.

  EVERYNTH

  Sort using Every Nth.

  NAMe

  Sort using Table/View name.

  REF

  Sort using reference table.

  ROWlimit

  Sort using row limit.

  STAtus

  Sort alphabetically using status.

  TYPe

  Sort by the type of table or view.

  The default for SORT is ascending order (ASC).

  Tables with no status are listed first.