Use the Index Search Selection Criteria dialog to enter column criteria or SQL statements for selected tables. The criteria that you enter on the Index Search Selection Criteria dialog is applied to all listed Archive Files stored on the selected media type.
To open the Index Search Selection Criteria dialog, right-click the grid in the Archive Directory Maintenance dialog and click one of the options in the Search submenu.
Click the down arrow to select a name from a superset of tables in all listed Archive Files stored on the selected media type. It is possible to have two or more tables with the same name, but different columns. Thus, the names of all columns in tables with the selected name are displayed in the Index Search Selection Criteria dialog.
Option for combining criteria for multiple tables:
You can use column criteria and SQL WHERE clauses for each table, as appropriate.
Use the Column Criteria tab to define selection criteria for any column in the table. Enter selection criteria for a specific column next to the column name.
Name of each column. You can rearrange the order in which the columns are displayed by dragging the grid row number. You cannot modify column names.
Enter a value or substitution variable in the Selection Criteria cell. Values for selection criteria must conform to SQL syntax and include appropriate relational or logical operators. To validate selection criteria, click outside the grid row. If the criteria is invalid, a message indicates the problem.
Use the SQL tab to create an SQL WHERE clause to handle selection criteria that is more complex than can be defined on the Column Criteria tab.
For example, to search for the desired set of data in a table in an Archive File, you may need to use a combination of AND and OR logical operators.
Enter the SQL WHERE clause portion of the SELECT Statement.
A list of the columns in the selected table. Select a column name to add it to the SQL WHERE clause before the cursor position.
A list of valid operators and symbols you can use in the SQL WHERE clause. Select an operator to insert it before the cursor position.
To begin the search, close the Index Search Selection Criteria dialog.
Depending on whether you selected the Only Use Index to Perform Search check box on the Archive tab of Personal Options, the search proceeds as follows: