You are here: LANSA for i User Guide > 2. Fields > 2.9 Code / Table File Lookup Rule > 2.9.1 Examples

2.9.1 Examples

These examples are provided to illustrate the use of the code/table file lookup rule facility:

Example 1

Field being checked:

Name

Type

Len

Dec

PRODNO

A

10

 

 

File details:

Name

Actual Keys

Keys Supplied

Comments

PRODMST

Product number

PRODNO

Check product is in product master

 

Example 2

Field being checked:

Name

Type

Len

Dec

TAXCDE

A

3

 

 

File details:

Name

Actual Keys

Keys Supplied

Comments

TAXTABL

Tax code type

INCOME

Check TAXCDE is a valid income tax code using alpha literal 'INCOME' in the key list.

 

Tax code

TAXCDE

 

 

Example 3

Field being checked:

Name

Type

Len

Dec

PARTNO

P

7

0

 

File details:

Name

Actual Keys

Keys Supplied

Comments

INVENT

Part number Warehouse number

PARTNO

Check PARTNO exists. This is a "partial" key validation check.

 

Example 4

Field being checked:

Name

Type

Len

Dec

INVNUM

A

8

 

 

File details:

Name

Actual Keys

Keys Supplied

Comments

INVNUM

Invoice number

INVNUM

Check INVNUM does not already exist. Reverse default error logic to get ERROR if key match is found, NEXT if key match is NOT found.