Using the Minus Operator Property Editor

See Also

The Minus Operator subtracts one stream from another. The order of subtraction is determined by the order in which you connect the input relations. You cannot subtract unlike operator attributes. The input schemas must be identical, with identical names and types for all attributes.

To create a Minus operator:

  1. Drag a Minus operator from the Palette to the Design view.
  2. Connect two or more input relations.
  3. Click the Minus operator icon. The property editor opens.
    The Expression field provides the order of the minus expression. This is initially determined by the order in which the inputs were connected. You can determine this by opening the properties pane for the Minus operator.The input ID list provides the order of the operators that the Minus operator subtracts Next. Open the properties pane for the relations feeding into the Minus operator and examine their ID.
  4. To change the order in the Expression dialog box, select the Order by drop down list, and a new primary operator. The new primary operator becomes the first operator on the Expression field.
    You can connect additional inputs to the Minus operator at a later time.
    You can also remove inputs. When you do so, the Expression is automatically updated.
See Also
Using the Tuple Based Window Operator Property Editor
Using the Intersect Operator Property Editor
Using the Distinct Operator Property Editor
Using the Union Operator Property Editor
Using the Union All Operator Property Editor
 

Legal Notices