Syntax

Use Literals For Merge:table_name

where table_name is the name of a table for which the current business component has a field that is a foreign key column to the named table.

Value

TRUE or FALSE.

If the value of this user property is TRUE, then during the Merge Records process, literals, instead of bind variables, are used as criteria in SQL statements for which the predicate is on a column that is a foreign key to table_name.

If the value of this user property is FALSE or the user property is not defined on a business component, then during the Merge Records process, bind variables are used in criteria in all SQL statements.

Usage

During the Merge Records process, bind variables are used for all predicates. In some cases, when the cardinality of the column is low, DB2 does table scans when using indexes is more efficient.

You can enable the Use Literals for Merge user property to direct the Merge Records process to generate literals in SQL statements for which the predicate is on a column known to have low cardinality. Add this user property to the business component on which Merge Records is run.

For example, add Use Literals For Merge:S_BU and set its value to TRUE. During the Merge Records process, literals are used instead of bind variables in SQL statements whose predicates are on a column that is a foreign key to S_BU.

You can inactivate this user property or modify its value. You can also create new instances of this user property.

Parent Object Type

Business Component

Functional Area

Merge