Setting Projection Properties

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

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.

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com