2 5 3 Code File Table Lookup Check Examples

LANSA Technical

2.5.3 Code File/Table Lookup Check 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.

 

 

Ý 2.5 Code File/Table Lookup Checks