User guide

Data Integration with Sybase Avaki Studio 71

The expressions menu

You don’t need to know any JavaScript to write simple expressions in Avaki Studio. In

any field where you can enter an expression, you can use Studio’s expressions menu to

choose the parameters, variables, logical operators, predefined functions and input col-

umn names with which you construct your expression. To display the menu, click in

the expression field, then right-click.

The submenus in the expressions menu are described below.

Global Parameters

The Global Parameters submenu lists the global parameters defined in this view

model. Select a parameter to enter it in the expression. For more on global parameters,

see “Using global parameters” on page 63.

Note If there are no global parameters in your model, the Global Parameters

submenu contains a disabled menu item: No Global Parameters.

Columns from the input element

There is one Columns from submenu for each input connected to the operator whose

expression you are editing. The names of these submenus include the names of the

upstream operators—for example, there might be Columns from Select1 and Col-

umns from SalesFiguresDS. Each submenu lists the columns in the upstream opera-

tor’s output result set. Select a column name to enter it in the expression.

Note If no inputs are connected to the current operator, the expressions menu

contains a disabled menu item: No Inputs.

Downstream Variables

The Downstream Variables submenu lists variables defined in operators downstream

of (that is, closer to the Result than) the current operator. Select a variable to enter it in

the expression.

Note If no variables are declared downstream of the current operator, the

Downstream Variables submenu contains a disabled menu item: No Down-

stream Variables.