Lookup components

A Lookup operation looks up a value corresponding to a key in a lookup table containing a list of key and value pairs. A static lookup table can be cached during the execution of a project, or the Lookup can be performed uncached and dynamically.

Component	Description
DB Lookup	Looks up values in a database. The lookup data is specified by the result set of a query returning exactly two columns: the lookup key and the lookup value. You can assign the value returned (lookup value) by the lookup to any attribute of the current record. The lookup table will be cached during project execution. Changes applied to the underlying database during project execution have no effect on the lookup result.
DB Lookup Dynamic	Uses a query that references the key value in the query's `WHERE` clause to perform a dynamic lookup. Unlike the DB Lookup component, DB Lookup Dynamic does not cache lookup information and performs one SQL lookup for each record that passes the component. During project execution, the lookup table data might be modified by concurrent database users (or even within the same project). In this case a non-dynamic database lookup might search for invalid data. Use DB Lookup Dynamic to ensure you locate the current value.

Component

Description

DB Lookup

Looks up values in a database. The lookup data is specified by the result set of a query returning exactly two columns: the lookup key and the lookup value.

You can assign the value returned (lookup value) by the lookup to any attribute of the current record. The lookup table will be cached during project execution. Changes applied to the underlying database during project execution have no effect on the lookup result.

DB Lookup Dynamic

Uses a query that references the key value in the query's WHERE clause to perform a dynamic lookup. Unlike the DB Lookup component, DB Lookup Dynamic does not cache lookup information and performs one SQL lookup for each record that passes the component.

During project execution, the lookup table data might be modified by concurrent database users (or even within the same project). In this case a non-dynamic database lookup might search for invalid data. Use DB Lookup Dynamic to ensure you locate the current value.