Qualify

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

Required?

No

Valid values

Key, Changed, or All

Default value

Key

Related topic

LogicalLog-parameters

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. The 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.

 

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