Adding a WHEN condition

Use the Add WHEN condition window to specify the WHEN argument for a table.

To create a WHEN condition:

  1. In the Add WHEN condition notebook, type a table owner and table name, or click to select names from the list box.

  2. On the Locate page of the notebook, expand the the list of column names and select the ones that you want to include in the WHEN condition. You can include the same column names more than once; for example, WHEN tsname = bob% or TSNAME=BSMITH.

  3. Select the comparison that you want. For example, use LIKE to find values that match some of the characters that you specify; or use = to find an exact match.

  4. Type the value you want to use in the condition. You can also use wildcard characters, such as % or the underscore _.

  5. Select either the Meet all conditions or the Meet any conditions radio button.

  6. Optional: To view or edit the SQL that you created, go to the Advanced page of the notebook.

  7. Click OK to save the changes and close the window.