Setting Projection Properties

Set the Projection operator to modify the input schema by adding or removing columns.

Follow these steps to configure a Projection operator:
  1. Double-click a Projection operator. The Projection Properties dialog appears.


  2. (Optional) Edit the Name and Description for this operator.
  3. Define the columns for your projection. You can click Project All to add column definitions for all of the columns in the input result set. This makes it easy to create your new set of columns if you only want to tweak the existing schema.
    Note: Use Project All before you define any other columns—doing so replaces all of your existing definitions.
  4. (Optional) Add columns, Delete columns, or change the order of the columns in the table (Move Up, Move Down). When you add a column, enter an expression that determines the column’s value in its Definition field.
  5. To edit the properties of a column, click on a cell and change its value as desired.
  6. (Optional) Check the Generate only distinct (non-duplicate) rows box. This option eliminates any row whose data duplicates that of a row already in the output.
  7. Click OK to save your changes and close the dialog.
Parent topic: Projection Operator
Related concepts
Expressions Menu
Performance of Sort-Based Operators in View Models
Related reference
Properties Dialog Field Descriptions

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.