M2M AD301 Uživatelská příručka stáhnout pdf (Strana 132)

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.

1 2 ... 127 128 129 130 131 132 133 134 135 136 137 ... 229 230

Žádné komentáře

M2M AD301 Uživatelská příručka Strana 132