DB Lookup Dynamic Properties List

The DB Lookup Dynamic Properties list identifies the required and optional properties of the DB Lookup Dynamic component.

Required Properties
Property	Description
Key Attribute	Select a key attribute from the list of input 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	Identify the method or driver to use to connect to the datasource.
Host Name	Identify the datasource. The options that appear in the Host Name list depend on the interface you select.
Query	Create a query that retrieves information from the datasource. Use the Query window to create a simple query, or click the Query Designer icon to open the Query Designer.

Optional Properties
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 datasource. 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 or owner you want to use as datasource. The objects that appear are restricted accordingly and new tables are created in the schema you specify.
Standardize Data Format	Convert incoming `DATE` and `NUMBER` information into a standard format that Sybase IQ InfoPrimer can move between systems that support different formats. Dates are converted into this format: `YYYY-MM-DD hh:mm:ss.s`. For example: 2005-12-01 16:40:59.123 Numbers are converted using a period (“`.`”) as the decimal separator.
Database Options	Set options that override performance defaults and control the behavior of some transactions.