User guide

Operator reference
120 Data Integration with Sybase Avaki Studio
• To reorder the columns, select one or more of them and click the Move Up or
Move Down buttons. (If you want to move multiple columns, the selection must be
contiguous.)
• You can edit the properties of each column. (See “Working with schemas” on
page 60 for information about the setting the name, type, precision, and scale of
columns.)
 Name: Click in the a column’s name field to rename it.
 Definition: Click in a column’s definition field to enter an expression that will be
evaluated each time through the loop to set the value of the column. The expres-
sion should evaluate to a value that’s appropriate for the column type you
choose. For our example, we would simply put the variable (fully qualified) in
the Definition field. When run, this column would have the values 0, 1, 2, 3, and
so on. For details on writing expressions, see “Using expressions within Avaki
Studio” on page 66.
 Type: Specify the type of the column. For our example, we would choose a
numeric type such as INTEGER.
 Precision: Specify the precision for the column, if applicable for the column’s
type.
 Scale: Specify the scale for the column, if applicable for the column’s type.