User guide

Operator reference
124 Data Integration with Sybase Avaki Studio
• You can edit the properties of each column. (See “Working with schemas” on
page 60 for information about setting the name, type, precision, and scale of col-
umns.)
 Name: Click in the a column’s name field to rename it.
 Expression: Click in the column’s Expression field to edit it. This may be any
JavaScript expression that you want to pass to the aggregate function, including
simple column names from the incoming result set. Click the “…” button to
open the Edit Expression dialog if you need more room than the table cell pro-
vides. You can also right click (either in the table cell directly, or in the Edit
Expression dialog) to show a context-sensitive menu of column names, vari-
ables, and functions that you can paste into the Expression field. For details on
using JavaScript expressions, see “Using expressions within Avaki Studio” on
page 66. For details on the context menu, see “The expressions menu” on
page 71.
 Function: Click the Function field and use the pull down list to choose the func-
tion you want to use for this column. The value of the Expression field will be
passed to this function for each row in the incoming result set. The functions are
described under “Aggregate functions” on page 110.
 Type: Specify the type of the column. Be sure to specify a numeric type (e.g.
INTEGER) for aggregate columns which use the Count function.
 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.