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:

• The LOOKUP function is not supported between Adabas data sources and FOCUS databases in either direction.
• The extended syntax of the LOOKUP function (parameters GE and LE) is not valid for Adabas data sources. LOOKUP can only retrieve values that match exactly. Refer to the FOCUS for S/390 documentation for more information.