Use the Table Specification window to define selection
criteria with an SQL WHERE clause.
To define selection criteria:
- Expand a folder in the Directory Explorer that contains
the access definition, expand the Access Definitions node,
and double-click the access definition. The Access
Definition Editor opens.
- Select the Tables tab.
- Select the table to which you will add selection criteria.
- Click Add Selection Criteria. The Table Specification window opens.
- Select the Selection Criteria tab. The tab displays a WHERE clause for the table.
- Enter selection criteria.
To display a list
of columns and operators, right-click the WHERE clause and click Content
Assist.
To add a variable, select a Variable
delimiter and click Insert Variable.
Click Check
Syntax to verify the syntax and identify errors.
- Click OK.
If the syntax
is not valid, a prompt will open to identify to error. You cannot
save the criteria if it contains errors.
- Save the access definition.