User`s guide

Customizing SQL and transformation rules
52 Sybase IQ ETL 4.1
Using expressions and procedures
An expression is a combination of identifiers and operators that can calculate
a single value. A simple expression can be a variable, a constant, an attribute,
or a scalar function. Operators can be used to join two or more simple
expressions into a complex expression.
Examples of expressions are:
'Miller'
uConcat("Time ", "goes by")
(uMid(SA_ORDERDATE, 1, 10) >= '1998-01-01')
[uTracelevel(3)]
A procedure is a programming unit that includes expressions, statements, and
control structures. A procedure can be written in JavaScript.
Examples of procedures are:
if (IN.PR_PRICE < 250)
OUT.PR_GROUP2 = 'low end' ;
else {
if (IN.PR_PRICE < 1000)
OUT.PR_GROUP2 = 'mid range';
else
OUT.PR_GROUP2 = 'high end';
}
Including variables
A variable is a symbolic name for a value. There are two basic properties of a
variable:
•Scope
• Datatype
The scope of a variable decides in which scope of the environment the variable
can be referenced.
There are:
• Port variables
• Component variables