Rocket® Enterprise Developer (formerly a product of Micro Focus or formerly a product of Open Text) documentation, created before Rocket Software acquired certain products from OpenText, may include outdated references to "Micro Focus" or "OpenText", both of which are trademarks of OpenText or its affiliates. Rocket Software is not affiliated with Micro Focus or OpenText and has since rebranded these products as Rocket® products. You may also encounter outdated links in this documentation. If you do, please contact Rocket Support (support@rocketsoftware.com) for assistance.
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:
- Click Edit.
- Type the literal value you want to use.
- 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.