Adding a new DEE where clause
DEE where clause defines condition to extract objects from IRC.
To add a new DEE where clause:
- Click Add Where Clause.
- Select the Table Name from the drop-down list. For example, BSEG.
- Select a field name. The drop-down list displays all the fields available in the selected table name.
-
Select an operator.
Note: Select the check box Not operator if you wish bypass the selected operator for your search.
- Provide the low value for the search. You can mention multiple comma separated values in this field.
- Provide the high value, if required. High value is not mandatory for the operator IN.
- Select compound operator to scope your search. Compound operators can be used for joining two operators for your search.
-
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.