The following tables list the required and optional properties of the DB Lookup Dynamic component.
Property |
Description |
---|---|
Key Attribute |
Select a key attribute from the list of IN-port attributes. This attribute populates the placeholder variable Lookup. |
Value Attribute |
Select the attribute to receive the value found by the lookup from the value attribute list. The lookup value returned overwrites any existing value. Both Key Attribute and Value Attribute might refer to the same attribute of the record structure therefore allowing the overwriting of a key with its corresponding value. |
Interface |
Specify the method or driver you want to use to connect to the data source. |
Host Name |
Identify the data source. The options that appear on the Host Name list depend on the interface you select. |
Query |
Create a query that retrieves information from the data source. Use the Query window to create a simple query, or click the Query Designer icon to open the Query Designer. See “Query Designer”. |
Property |
Description |
---|---|
User and Password |
Identify an authorized database user, and protect the database against unauthorized access. |
Default Value |
Assign a default value to the value attribute, in case the key value was not found in the lookup table. |
Use Key Value |
Assign the key value to the value attribute instead of the default, if the lookup fails. |
Lookup Empty/Null Keys |
Perform the lookup even for empty or NULL key values. If not selected, the default method applies. |
Lookup Key Value |
Specify a value for the lookup key populating the Lookup variable for testing the query at design time |
Database |
Identify the database to use as data source. If you select this option, you must also select an appropriate interface, and in some cases, specify an appropriate user ID and password. |
Schema |
Identify the schema/owner you want to use as data source. The objects that appear are restricted accordingly and new tables are created in that schema. |
Standardize Data Format |
Convert incoming Dates are converted into a format that includes the year, month,
day, hour, minute, seconds, and fraction of a second: For example, 2005-12-01 16:40:59.123 Numbers are converted using a period (“ |
Database Options |
Set options that override performance defaults and control the behavior of some transactions. |