User guide

Operator reference
150 Data Integration with Sybase Avaki Studio
Connections
The Iterator operator takes either one or two input result sets. If there is a second
input, it is designated the range input and its rows are used to perform the iteration.
Iterator produces exactly one output result set and its schema is the same as that of
the primary input.
Iterator properties
Double-click an Iterator operator to display the Iterator Properties dialog. You can
edit the name and description as described in “Properties dialogs” on page 58.
Use the remaining fields to define the iteration as follows:
• Range Input: If you have connected two inputs to your Iterator, designate one of
them as the range input using this pull-down list. If you’re using a range input, the
operator automatically loops through each row in the range result set, stopping
when there are no more rows. You must set up other expressions to set the value of
any variables based on the range result set’s columns. However, you need not main-
Required Connection
Optional Connection