2.5.2 Key Field or Literal
Specify the key that is to be compared with the keyed index of the file looking for a "match" (i.e.: a record with an identical key in the file).
At least 1 key field is required. The entire key list supplied is checked for compatibility with the actual key(s) of the file. The key list specified can be a full or partial key to the file. A warning is issued if a partial key list is specified.
Rules
Allowable values are:
- For field level validations, the name of the current field.
- For file level validations, a field from the current file.
- An alphanumeric literal (in quotes) such as 'NSW', 'BALMAIN'
- A numeric literal such as 1, 14.23, -1.141217.
- A system variable name such as *BLANKS, *ZERO, *DATE or any other system variable defined at your installation.
- A process parameter such as *UP01, *UP02, etc.
Tips & Techniques
- A code/table file lookup is typically defined for file level validation checks only.