[ |../../index.htm#lansa/l4wtgu02_0155.htm]
You are here:

2.6.2 Key Column or Literal

Specify the key that is to be compared with the keyed index of the table looking for a "match" (i.e.: a record with an identical key in the table). 
At least 1 key column is required. The entire key list supplied is checked for compatibility with the actual key(s) of the table. The key list specified can be a full or partial key to the table. 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 table level validations, a column from the current table.
• 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 lookup is typically defined for table level validation checks only.

[ |../../index.htm#lansa/l4wtgu02_0155.htm]