Adding a new DEE where clause

DEE where clause defines condition to extract objects from IRC.

To add a new DEE where clause:

  1. Click Add Where Clause.
  2. Select the Table Name from the drop-down list. For example, BSEG.
  3. Select a field name. The drop-down list displays all the fields available in the selected table name.
  4. Select an operator.
    Note: Select the check box Not operator if you wish bypass the selected operator for your search.
  5. Provide the low value for the search. You can mention multiple comma separated values in this field.
  6. Provide the high value, if required. High value is not mandatory for the operator IN.
  7. Select compound operator to scope your search. Compound operators can be used for joining two operators for your search.
  8. Select a filter type. These filter types are available:
    • Date - Create : This filter is specific to date fields and is used for full extraction.
    • Date - Update: This filter is specific to date fields and is used for Incremental extraction.
    • Additional: This filter is generic.
    Consider this example.

    In this scenario, the rows, of the field name ABSBT, having the values ABCD , ASERF are extracted.