DB Lookup Dynamic

The DB Lookup Dynamic component performs a dynamic lookup by referencing the key value in the query WHERE clause.

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 may be modified by concurrent database users (or even within the same project). In this case, a database lookup that is not dynamic may search for invalid data. Use DB Lookup Dynamic to ensure you locate the current value.

Another typical use for this component is a lookup table that exceeds the memory available on the local machine. The DB Lookup Dynamic component provides a slower-performing lookup, but requires no cache memory, as it performs the lookup on a record-by-record basis.

• Configuring a DB Lookup Dynamic Component
  Add and configure a DB Lookup Dynamic component to your project.
• Example
  Assume you want to replace the product number used for German products by the product number used in the US. The German products are in the table PRODUKTE(PR_NUMMER, PR_NAME, PR_PREIS). Your IN-port for the DB Lookup Dynamic component therefore contains these three attributes.
• DB Lookup Dynamic Properties List
  The DB Lookup Dynamic Properties list identifies the required and optional properties of the DB Lookup Dynamic component.
• Running DB Lookup Dynamic Demos
  Sybase IQ InfoPrimer includes a demonstration for the DB Lookup Dynamic component. These demos are available as Flash demos and as sample projects in the demo repository.