2.3.1 Value

Specify the value to add to the values list or change in the value list.

At least one entry in the list is required, and a maximum of 50 entries can be specified. Values are checked for type and length compatibility.

Rules

Allowable values include:

• An alphanumeric literal (in quotes) such as 'NSW', 'BALMAIN'

• A numeric literal such as 1, 14.23, -1.141217.

• Another column name such as CUSTNO, INVNUM, etc.

• 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

• You may wish to use 2.4 Range of Values Checks depending upon your list contents. For large numeric lists, a range check may be more appropriate.