To specify search criteria (a WHERE clause)

In the OpenESQL Assistant, click the Search Criteria tab.
From the Column drop-down list, click a column name.
From the Conditional Operator drop-down list, click a conditional operator.
From the Target Type drop-down list, click a target type.
Do one of the following:
- If you have selected a target type of Special Register, type a value for your special register into the Target Value field.
- If you have selected a target type of Column Name, click a column name from the Target Value drop-down list.
- If you have selected a target type of Literal:
  1. Click Edit.
  2. Type the literal value you want to use.
  3. Click OK.
- If you have selected a target type of Host Variable, the target value is set for you. Proceed to step 6.
Insert the search criteria (WHERE clause) into your code by clicking the right-pointing arrow .
To add a subsequent set of criteria, click either AND or OR and repeat this procedure. Optional.

Note:

Code you place into the right-hand pane also appears automatically in the generated query.
To remove search criteria, click the line of code you want to remove in the right-hand pane, then click the left-pointing arrow . This places the criteria back into the appropriate fields on the left side of the tab, enabling you to edit it. Moving search criteria from the right-hand to the left-hand pane also removes the associated COBOL code from the automatically generated query.