PowerExchange for JDBC V2 User Guide

Back Next

Lookup Properties

Specify the lookup properties to look up a JDBC V2 table. You can configure a lookup condition to look up data from the JDBC V2 table.

There are two types of option that you must select in the

Specify by

property to configure a lookup condition:

Value

: Select this option if you want to configure a lookup condition using the column name.

Parameter

: Select this option if you want to parameterize the lookup condition.

The following table describes the lookup properties that you can specify for a JDBC V2 lookup if you select the

Value

option:

Property	Description
Lookup Column	The name of the columns that you want to look up.
Operator	Operators that you can use to filter records. You can select one of the following operators: =, !=, <=, >=, and
Input Port	The input source port.

The following table describes the lookup properties that you can specify for a JDBC V2 lookup if you select the

Parameter

option:

Property	Description
Parameter	The name of the parameter that you want to use to look up. You can also create a new parameter. Click New to create a new parameter. Enter the parameter name and specify an expression in the New Parameter dialog box. Click Validate to check if the expression that you specified is valid or not.