Key Loop Expression Tokens

Expression

Description

<IF ASCENDING>

The key is ordered in ascending sequence.

<IF AUTO_SEQUENCE>

The first segment of the key is an auto-sequence segment (ISAM Rev 6).

<IF AUTO_TIMESTAMP>

The first segment of the key is an auto-time-stamp key, of one of the two types shown below. ISAM Rev 6 (Synergy/DE 10.1.1 or higher).

<IF AUTO_TIMESTAMP_CREATED>

The first segment of the key is an auto-time-stamp key with values that are set only when records are first created. ISAM Rev 6 (Synergy/DE 10.1.1 or higher).

<IF AUTO_TIMESTAMP_UPDATED>

The first segment of the key is an auto-time-stamp key with values that are set whenever records are updated. ISAM Rev 6 (Synergy/DE 10.1.1 or higher).

<IF CHANGES>

The key value may be changed.

<IF DESCENDING>

The key is ordered in descending sequence.

<IF DUPLICATES>

The key allows records with duplicate key values.

<IF DUPLICATESATEND>

Duplicate key values are inserted after any existing records with the same key value.

<IF DUPLICATESATFRONT>

Duplicate key values are inserted before any existing records with the same key value.

<IF FIRST_SEG_NOCASE> 

The first segment of the key is a non-case sensitive alpha field.

<IF MULTIPLE_SEGMENTS>

The key has more than one segment.

<IF NOCHANGES>

The key value may not be changed.

<IF NODUPLICATES>

The key does not allow multiple records with the same key value.

<IF NULLKEY>

The key is a null key.  See <KEY_NULLTYPE> and <KEY_NULLVALUE>.

<IF NULLVALUE>

The key has a null key value specified.  See <KEY_NULLTYPE> and <KEY_NULLVALUE>.

<IF SINGLE_SEGMENT>

The key only has one segment.