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.
You can use SBN expressions in:
Expressions
SQL queries
Pre-SQL and post-SQL statements
Transformation rules
File names
Path definitions
Component properties
URLs
A literal is a string surrounded by quotes. If you use SBN in a literal, the SBN is evaluated first.
‘Arrival Date: [uDate(‘now’, ‘localtime’)]’
This expression specifies the path of a file in the Text Data Provider:
[uSystemFolder(‘APP DEMODATA’)]\PRODUCTS.TXT
In the Property window of components, the Eval column
indicates whether a value entered is evaluated to resolve SBN expressions.
For many property items, the Eval column is optional. To toggle
the Eval check box, right-click the property item and select Evaluate.
