User`s guide

Customizing SQL and transformation rules
54 Sybase IQ ETL 4.1
Using Square Bracket Notation
Expressions and SQL statements can contain SBN expressions that are
evaluated before the expression or SQL statement is executed by the Sybase
ETL Server. An SBN expression is surrounded by square brackets [..]. The
notation
SBN expression is used as a synonym for an indirect expression.
SBN expressions can be used in:
• Expressions
• SQL Queries
• Pre-SQL and post-SQL statements
• Transformation rules
• File names
• Path definitions
•URLs
Examples
A literal is a string surrounded by quotes. If you use SBN in a literal, the SBN
is evaluated first.
‘[uConcat(‘Arrival Date: ‘, uDate(‘now’, ‘localtime’),'
Time: ‘, uTime(‘now’, ‘localtime’)]’
The following expression is used to specify the path of a file in the Text Data
Provider:
[uSystemFolder(‘APP DEMODATA’)]\PRODUCTS.XML
Note In the Property section of the components, the Eval column indicates
whether a value entered is evaluated to resolve SBN expressions. For many
property items, this is an optional value. To toggle the Eval check box, right-
click on the property item line and select Evaluate.
Entering SQL statements
SQL queries are used for all components that extract data, mainly the Data
Provider Components and the Staging Components. Queries are mandatory for
those components because they define OUT-Port structure.
To enter a query for the component, select the Query option of the Query
property.