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
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
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.
