Drag the DB Lookup Dynamic component onto the Design window.
In the Design window, connect the DB Lookup’s IN-port with the OUT-port of the component that provides the inbound data.
In the Properties window, specify the interface and host name.
See “DB Lookup Dynamic properties list” for specific field requirements.
Specify the Key Attribute holding the value to look for and Value Attribute to take the lookup result value. You can replace a value by choosing the same attribute for both.
Specify a Lookup Key Value to be used when designing and testing the lookup Query.
Click the Query icon to open the Query window.
On the Query window, create and save the query to retrieve the lookup data. Design your query to return the lookup value from the source table. Use the predefined variable Lookup in the where clause of your Query as a placeholder for the Lookup Key. See “Using SBN expressions”.
Resetting default lookup key values
During simulation the Key Attribute values from the incoming data stream are assigned to the predefined variable Lookup. To reassign the specified Lookup Key Value to this variable:
Right-click the DB Lookup Dynamic component.
Select Reset Lookup Key value.
