FIELD
Identifies the location of the index data and can provide default and constant index values.
- Required
- Yes
- Default Value
- (None)
- Data Type
- AFP, Line, SCS, SCS-Extended
You must define at least one field. You can define
up to 128 fields. The 400 indexer
supports the following types of fields:
- Trigger field, which is based on the location of a trigger string value.
- Constant field, which allows you to provide the actual index value that is stored in the database.
- Transaction field, which you can use to index input data that contains one or more columns of data sorted in ascending sequence (from lowest to highest). Because it is not always practical to store every index value in the database, the 400 indexer extracts the first and last sorted values in each group. The data is sorted according to the collating sequence of the code page.
- Mask field, which uses a mask to match data from the field columns.