Using Prompted tab

About this task

You use the Row conditions pane of the Prompted menu to specify the row conditions for tables. The Prompted menu of the Table editor is similar to the Prompted Query editor, except that only the Sort conditions and Row conditions panes are available.

Procedure

  1. Right-click a table in the Workspaces view and select Open With > Table Editor.
    The table opens in the editor window.
  2. Click the Prompted tab.
    The Prompted menu opens with only the Sort conditions and Row conditions panes available.
  3. Click Add Row Condition in the Row conditions toolbar.
    The Row Conditions window opens.
  4. If you are specifying more than one condition that must be met for a row to be included in the table, you must indicate how each condition will be connected using the Connector radio buttons. If you select And, then the current condition that you are specifying and the previous condition (listed in the Row conditions pane of the Prompted menu) must be met in order for the row to be included. If you select the Or, then the current condition or the previous condition can be met in order for the row to be included. When you connect multiple conditions using both And and Or, then the rules of the data source determine how the conditions are processed.
  5. Select a column from the Select a column from the list list box to examine for inclusion in the table.
    The Select a column from the list list box lists all the columns that will be included in the table. To specify a conditional expression that will determine the column, enter an expression in the Or, enter an expression here field. Click the ellipsis (...) to open an expression builder that will help you build the conditional expression.
  6. Specify the operator for the row condition expression using the Operator field.
    To use the operator as is, select Is. To change the operator to its negative opposite, click the Is Not. For example, to specify "Is Not Equal To" select Is Not and select the Equal To operator in the list. You cannot use the Starting with, Ending with, or Containing operators if the left and right sides of the row condition expression have numeric data types. You cannot use any of the spatial predicates unless the left and right sides have spatial data types.
    Note: If IBM Db2 Spatial Extender is installed on the database, you are able to work with spatial data types: points, lines, and polygons. But you cannot use any of the spatial predicates unless the left and right sides have spatial data types.
  7. Specify the condition for which to check the rows in the Right Side area.
    1. You can use the expression builder button to help you build the conditions.
    2. To add row conditions from a file of any format with the values that are separated by commas, click Import Conditions From File.
    3. To specify row conditions from a set of query results, click Import Conditions via Executing SQL Query, and enter the SQL text of a query.
    4. You can use the Remove Condition or Remove All Conditions buttons to remove one or all row conditions.
  8. Click Add.
    The row condition is added and displayed in the Row conditions pane of the Prompted menu. Repeat this process for each condition that you want to add. When you have finished specifying each condition, click Close. The Row Conditions window closes. You are returned to the Prompted menu.