collection-name

       Is the name of the collection to be sorted.

    BY

       Is an optional language element you can use to clarify syntax.

    sort-key

       Is a field whose contents form the basis for the sort. You can
       also use a value expression as a sort key as long as the value
       expression does not contain a SORTED BY or REDUCED TO clause.

       The sort key can be preceded or followed by a keyword that
       determines the order in which DEC DATATRIEVE sorts the records
       in the collection. ASCENDING is the default order.

       To specify the sort order for each sort key, use one of the
       following terms:

       ASC[ENDING]
       DESC[ENDING]
       INCREASING
       DECREASING

       If you specify more than one sort key, use a comma to separate
       each sort key from the next.