Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see High-speed Apply Engine 13.1.

Qualify

For Db2, the Qualify parameter specifies how the High-speed Apply Engine selects the rows in the target table to be updated. High-speed Apply Engine uses the value that you specify to generate a WHERE clause as it applies SQL statements to the target table.

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[LogicalLog]

Abbreviation

None

DBMS

Db2

Required?

No

Valid values

Key, Changed, or All

Default value

Key

Usage

Specify one of the following values for the Qualify parameter:

  • Key indicates that only those columns designated as key values are included in the WHERE clause. Key is the default value.
  • Changed indicates that all key columns and any column with changes are included in the WHERE clause of the SQL statement.
  • All indicates that all columns referenced in the input file are included in the WHERE clause.

For more information about what columns can be included in the generated WHERE clauses, see Command and syntax reference.

Related topic

LogicalLog-parameters



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*