+---------------------------------+
|    SYS(14, <expN1> [, <expN2>   |
|       <expC>])                  |
+---------------------------------+

-----------------------------------
Returns index expression of an open single-entry .IDX index file, or
index expressions for tags in compound .CDX index files.
Return value - Character
-----------------------------------

<expN1>
        Specifies which index expression to return from open index files or
tags.

<expN2> | <expC>
        Optional work area or alias.

+---------------------------------+
|           Description           |
+---------------------------------+
SYS(14) returns the index expression of an open single-entry .IDX index
file, or the index expressions for tags in compound .CDX index files.
An index expression is specified when an index file or tag is created
with INDEX.  The index expression determines how a database is displayed
and accessed when an index file or tag is used to order a database.

For additional information on creating index files and tags and index
expressions, see INDEX in this help facility.  SYS(14) is similar to the
KEY() function.

USE and SET INDEX both support an index file list that lets you open
index files for a database.  Any combination of single-entry .IDX index
files, structural compound or independent compound index files may be
included in the index file list.

The numeric expression <expN1> specifies which index expression to
return from the open index files or tags.  SYS(14) returns index
expressions from open index files and tags in the following order:

. Index expressions from single-entry .IDX index files (if any are open)
are returned first.  The order the single-entry index files are included
in USE or SET INDEX determines the order the index expressions are
returned.

. Index expressions for each tag in the structural compound index (if
one is present) are returned next.  The index expressions are returned
from the tags in the order the tags are created in the structural index.

. Index expressions for each tag in any open independent compound
indexes are returned last.  The index expressions are returned from the
tags in the order the tags are created in the independent compound
indexes.

The null string is returned if <expN1> is greater than the total number
of open single-entry .IDX files and structural compound and independent
compound index tags.

Index expressions are returned from index files open in the currently
selected work area unless you include an optional work area or alias.
To return index expressions from index files open in a specific work
area, include the work area number <expN2>, or the database alias
<expC>.

If a database doesn't have the alias you specify, the message "Alias not
found." is displayed.

+---------------------------------+
|            Examples             |
+---------------------------------+
INDEX ON cust_id TO cus_cus
INDEX ON company TO cus_com
SET INDEX TO cus_cus, cus_com
? SYS(14,1)

? SYS(14,2,'customer')

USE

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

See Also:  CDX(), KEY(), INDEX, MDX(), NDX(), REINDEX, SET INDEX, SET
ORDER, SYS(), TAG()

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