User guide

Data Integration with Sybase Avaki Studio 165
Select
Select
Use a Select operator to filter rows from an input result set. You provide a Boolean
expression that is tested for each row. If the expression evaluates to true for a given
row, the row is passed to the output. Otherwise it is thrown away. Select does not
change the schema of its input result set.
Connections
The Select operator takes exactly one input result set, which can be the output of an
Input Source or of any other operator. It produces exactly one output result set whose
schema is the same as that of the input.
Select properties
Double-click a Select operator to display the Select Properties dialog. You can edit the
name and description as described in “Properties dialogs” on page 58.
Where: Define your select by supplying a Boolean expression for this field. When this
expression evaluates to true for a given row, that row will be included in the output;
rows for which this expression evaluates to false will not be included. See “Boolean
expressions” on page 66 for information on using Boolean expressions in Studio. For
example, if you want to list only those employees in your data whose salary (the
Required Connection