+---------------------------------+
|            SET ORDER            |
+---------------------------------+
SET ORDER TO
        [<expN1> | <.idx index file>
        | [TAG] <tag name>
        [OF <.cdx file>]
        [IN <expN2> | <expC>]
        [ASCENDING | DESCENDING]]

-----------------------------------
Designates controlling master index file or master tag.
-----------------------------------

<expN1>
        May be used to designate master index file or master tag.  <expN1>
refers to the index files as listed in USE or SET INDEX. Open .IDX index
files are numbered first in the order they appear in USE or SET INDEX.
Tags in the structural index file (if one exists) are then numbered in
the order the tags were created.  Any open independent .CDX compound
index files are numbered in the order they were created.

<.idx index file>
        Explicitly designate an .IDX index file as master index file by
including the name of a <.idx index file>.

[TAG] <tag name>   [OF <.cdx file>]
        To designate a tag of a .CDX index file as the master tag, include the
<tag name>.  The <tag name> may be from the structural index file or any
open .CDX compound index file.  The TAG keyword is optional.

        If identical tag names exist in open .CDX compound index files, include
OF <.cdx file> with the name of the <.cdx file> containing the desired
tag.

        If duplicate .IDX files and tag names exist, the .IDX file will take
precedence.

IN <expN2> | <expC>
        SET ORDER designates the master index or master tag for database open
in currently selected work area.  You can designate master index file or
master tag for a database open in another work area by including the
work area number <expN2>, or the database alias <expC>.

ASCENDING | DESCENDING
        Specify whether database records are displayed and accessed in
ascending or descending order.

-----------------------------------

See Also:  INDEX, ORDER(), SET INDEX, SYS(14) Index expression, SYS(21)
Master index number, SYS(22) Master tag/index name, SYS(2021) Filtered
index expr

-----------------------------------