Defining selection criteria for an entity

You can use the Entity Specification editor to define selection criteria for an entity in a selection policy.

Selection criteria allow you to pinpoint the data you want to process. You can select data according to values in one or more attributes. Selection criteria must conform to SQL syntax and include relational or logical operators.

To define selection criteria for an entity:

  1. From the data access plan editor, click Selection. The selection policy editor opens.
  2. Click the Entity Specification heading. The Entity Specification editor opens.
  3. From the Entity Name list, select the entity to which you want to add selection criteria.
  4. Click Add/Edit Entity Selection Criteria. The Entity Selection Criteria window opens.
  5. Enter SQL syntax in the editor area. For convenience, you can select the Attributes, Operator Symbols, or Logical Operators to include.

    Click Check Syntax to identify SQL syntax errors.

  6. Click OK to return to the Entity Specification editor. The selection criteria is displayed in the Selection Criteria for area.
  7. Select View Selection Criteria SQL Summary to view the attribute selection criteria in the Select statement for the entity.
  8. Click File > Save.