2.3.2 List Examples
These examples are provided to illustrate the use of the list of values rule facility:
Example 1
Column being checked:
Name | Type | Len | Dec |
|---|---|---|---|
STATE | A | 3 |
List of values:
List Of Values | Comments |
|---|---|
'NSW' | Check for valid Australian state mnemonic. |
Example 2
Column being checked:
Name | Type | Len | Dec |
|---|---|---|---|
NAME | A | 7 |
List of values:
List Of Values | Comments |
|---|---|
*BLANKS | A blank name is an error. Reverse the default error logic to get ERROR if in list, NEXT if not in list. |
Example 3
Column being checked:
Name | Type | Len | Dec |
|---|---|---|---|
COMPNO | P | 1 | 0 |
List of values:
List Of Values | Comments |
|---|---|
1 | Company number must be 1, 2 or 3. |
Example 4
Column being checked:
Name | Type | Len | Dec |
|---|---|---|---|
YEAR | A | 2 |
List of values:
List Of Values | Comments |
|---|---|
*LASTYEAR | Year must equal one of the site defined system variables *LASTYEAR, *THISYEAR or *NEXTYEAR |