User guide

Data Integration with Sybase Avaki Studio 119
Generator
that would be valid inside a function body. See “Using expressions within Avaki Stu-
dio” on page 66 for details on using JavaScript code within Studio.
Increment: This field contains expressions which increment the variables you initial-
ized in the previous field. In our example, we would simply increment our counter
variable. Here, too, you can enter any JavaScript code here that would be valid inside a
function body. See “Using expressions within Avaki Studio” on page 66 for details on
using JavaScript code within Studio.
Condition: This field contains a Boolean expression. While it evaluates to true, the
operator will continue to be called to provide additional rows of data. When it evalu-
ates to false, the iteration will cease. In our example, we would want to check for our
counter being less than or equal to the value 100. See “Boolean expressions” on
page 66 for details on constructing Boolean expressions.
Defining the output columns
When you define a Generator operator, you need to specify the schema that the out-
put result set will have, as well as the values the columns will have for each iteration
through the loop. You do this using the Column Definitions tab in the Generator Prop-
erties dialog.
• Click the Add button to add a column definition to your schema.
• To delete one or more columns, select them and click Delete.