The LOOKUP Function

The LOOKUP function, used in FOCUS MODIFY procedures, retrieves data values from cross-referenced data sources joined dynamically with the JOIN command. The function is valid in both MODIFY COMPUTE and VALIDATE commands.

The syntax for the LOOKUP function is

 
rfield/I1 = LOOKUP(field);

where:

rfield

Contains the return code (1 or 0) after the LOOKUP function executes.

field

Is the name of any field in a cross-referenced data source. After the LOOKUP, this fieldname contains the field's value for you to use as needed.

To use this feature most efficiently with Adabas, specify a cross-referenced field for which an Adabas descriptor has been established.

Note:


Information Builders