Key Loop Expression Tokens

Key Loop 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 FIRST_UNIQUE_KEY>
 

The key being processed is the first unique key in the file.

<IF LITERAL_SEGMENTS>
 

The key being processed has one or more literal value segments.

<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 PRIMARY_KEY>

The key is the primary key. In order for this expression to return true the key must be the first key defined for the structure, and the key of reference must be 0.

<IF SINGLE_SEGMENT>

The key only has one segment.