Lookup Components
A lookup operation looks up a value that corresponds to a
key in a lookup table that contains a list of key and value pairs.
A static lookup table can be cached during the execution of a project,
or a lookup can be performed uncached and dynamically.
- DB Lookup
The DB Lookup component looks up values in a database. The lookup data is specified by the result set of a query that returns exactly two columns—the lookup key and the lookup value.
- DB Lookup Dynamic
The DB Lookup Dynamic component performs a dynamic lookup by referencing the key value in the query WHERE clause.
Created May 24, 2011. Send feedback on this help topic to Sybase Technical Publications:
pubs@sybase.com