Index Declarations for Network Record-Types

How to:

The adapter supports indexing using IDMS Integrated Indexes.


Top of page

x
Syntax: How to Declare Attributes for Integrated Indexes

The following attributes apply to declarations for Integrated Indexes. This declaration is not used in LRF Access Files. See Access File Syntax for an example of an index declaration.

IXSET=ixset, [IXFLD=ixfld, IXDUP={Y|N}, IXORD={A|D}] [, IXAREA=ixarea]

where:

ixset

Is the IDMS set name of the index set.

ixfld

Is the corresponding field name or alias with FIELDTYPE = I. If the key is composed of multiple fields, separate the individual field names or aliases with slashes.

This attribute should not be included if the index is not defined with a sorted order in IDMS.

An index declaration without IXFLD has to be placed immediately after the segment declaration for this index. Only the first declaration of this type will be used, if multiples are defined. An index declaration without IXFLD can be used only for access by area sweep. IDMS uses one of the non-sorted order types defined for the index: FIRST (LIFO), LAST (FIFO), NEXT (simple list), or PRIOR (reverse list).

IXDUP={Y|N}

Is Y if duplicate index values are allowed, N if not. This attribute should not be included if the index is not defined with a sorted order in IDMS.

IXORD={A|D}

A indicates ascending, D indicates descending sort order of index. This attribute should not be included if the index is not defined with a sorted order in IDMS.

ixarea

Is the IDMS area name of the index. The IXAREA attribute is omitted unless the index entries reside in a different area from the record-type being indexed.


Information Builders