Most component properties can contain SBN expressions that are evaluated before being used by the Sybase ETL Server on project configuration, simulation, or execution. An SBN expression is a JavaScript expression surrounded by square brackets [..]. Multiple SBN expressions can be used within a single string value.
You can use SBN expressions in component properties like:
SQL queries
Processing 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.
‘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.
